Calculate days in month

[IanT]

I have a startdate and enddate. I want to calculate the total working days in a selected month ie
Startdate Endate Days in February
25-02-02 01-03-02 = 4


Can anyone help!

 

[Geoff Codd]

check out the datediff function under help

 

[Rich]

Look up this article Article ID: Q97757
and search here there have been several postings regarding Work Days especially if you want to include Bank Holidays.
HTH

 

[Geoff Codd]

NETWORKDAYS
Returns the number of whole working days between a start and end date, excluding weekends and any identified holidays.

If this function returns the #NAME? error value, you may need to install msowcf.dll.

Syntax

NETWORKDAYS(start_date,end_date,holidays)

Start_date is a date that represents the start date.

End_date is a date that represents the end date.

Holidays is an optional range of one or more days (holidays) to exclude from the working calendar.