MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Calculating workdays vs Calendar Days


Posted by Glenda McNeil on June 22, 2000 5:55 AM

I am trying to write a formula which would calculate the number of workdays within a given period, vs. counting all the days (calendar days).

EX. June 1 to 30 would have 30 days, but could I ignore Saturdays and Sundays in the count?

Posted by Mike Faulkner on June 22, 0100 6:46 AM

You'll want to use the WORKDAY or NETWORKDAYS formula.

NETWORKDAYS(start_date,end_date,holidays)

Excellent descriptions are in Excel Help.

Mike