|
View Full Version : Calculate days in month IanT 03-19-2002, 01:52 AM 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 03-19-2002, 02:03 AM check out the datediff function under help Rich 03-19-2002, 04:13 AM 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 03-19-2002, 05:01 AM 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. |