Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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?


Check out our Excel Resources

Re: Calculating workdays vs Calendar Days

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.