Can you count weekdays in a range?

[Gazzamuffin]

Is there a way of counting the number of weekdays between the current date and the first day of the next month?

 

[Guest_imported]

Gazza,

Try this....

if month(currentdate) = 12 then
dateserial(year(currentdate)+1,01,01)
- currentdate
else
dateserial(year(currentdate),month(currentdate) + 1,01)
- currentdate

You will be counting the number of days to the first day of next month unless its December when you will count upto the 1st of January of the next year.

 

[Gazzamuffin]

Cheers for that, but it is counting all days to the end of the month. How do I exclude Saturday and Sundays.

 

[Gazzamuffin]

Cheers for that, but it is counting all days to the end of the month. Any idea how I exclude Saturday and Sundays?

 

[schusser]

I got this response from Ken Hamady to same question. It worked for me.

Good luck.

 

[schusser]

Sorry... Let's try that again..
FAQ149-243 has a formula for calculating the number of business days between any two dates. It also does holidays, but you could skip that part. You need to give it the beginning and end dates.