how to calulate number of days subrating sundays alone

Question

0.00/5 (No votes)

See more:

Working days textbox datetimepicker(calendar)

Netpayabledays textbox

Working days 31 datetimepicker(calendar) when i choose particular month that days displayed i done through coding.

Netpayabledays textbox 26( i want subracting sundays from selecting a particular month. remaining days to be displayed in netpayable days textbox.

for your understand i send the attach file

Posted 9-Jul-12 5:15am

Member 8054539

Add a Solution

Comments

Tim Corey 9-Jul-12 14:30pm

This question is quite unclear. We cannot understand what youw ant to do based upon this description. Instead of writing short phrases, please try to develop a paragraph that explains what you are attempting to do, what outcome you would like to see, and where you are having difficulties.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2012-07-09T08:29:00

It is unclear what you want.
But if I guess correctly, you want to calculate weekdays (workdays) in a month. You can use System.DateTime.DayOfWeek[^] property to see what day of week is a specific date.
Here you have some methods: http://stackoverflow.com/questions/1820173/calculate-the-number-of-weekdays-between-two-dates-in-c-sharp[^], you just have to change them to take only Sunday as weekend, and Saturday as weekday/workday.

Update: here i found the most elegant one: http://stackoverflow.com/questions/4022993/how-to-get-a-list-of-week-days-in-a-month[^]. With a little adaptation:

C#

public static int GetWorkdays(int year, int month)
        {
            return Enumerable.Range(1, DateTime.DaysInMonth(year, month))
                             .Select(day => new DateTime(year, month, day))
                             .Where(dt => dt.DayOfWeek != DayOfWeek.Sunday)
                             .Count();
        }
}