Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Calculating workdays vs Calendar DaysPosted 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 DaysPosted by Mike Faulkner on June 22, 0100 6:46 AM
You'll want to use the WORKDAY or NETWORKDAYS formula.
Excellent descriptions are in Excel Help.
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.