How do I Exclude Weekends and Holidays from formulas

[Brandon]

I am trying to do the following.

I have lead times for loans in closing and the lead times
change daily. I want to publish a report like the one
below projecting the new close date. I need to omit
weekends and holidays (if possible) from my projection
dates. Anyone know how to do this?

Today's Date 8/15/2003

Closing Days Earliest Date Can Close
6 August 21, 2003

 

[Chip Pearson]

Brandon,

You can use the WORKDAY function to do this. Something like

=WORKDAY(TODAY(),NumDays,HolidayRange)

where NumDays in the number of business days, and HolidayRange is
a range of cells containing the list of holidays to exclude.

See help for more documentation about WORKDAY.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)