How do I Exclude Weekends and Holidays from formulas

  • Thread starter Thread starter Brandon
  • Start date Start date
B

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
 
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)
 
Back
Top