dates: no weekends and no hollidays

  • Thread starter Thread starter Mortir
  • Start date Start date
M

Mortir

a have a formula that returns a date. now id like to check the date
whether its a weekday or a holliday and if it is -than to return the
first workday after...
 
Look at the WORKDAY() function.
If not available: Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|a have a formula that returns a date. now id like to check the date
| whether its a weekday or a holliday and if it is -than to return the
| first workday after...
 
a have a formula that returns a date. now id like to check the date
whether its a weekday or a holliday and if it is -than to return the
first workday after...
Click to expand...

=WORKDAY(your_formula-1,1,[holidays])


[holidays] is a range where you have listed all the holiday dates during the
time frame of interest.

--ron
 
Back
Top