Calculate a future date, not including Sat/Sun or Bank Holidays

  • Thread starter Thread starter RR
  • Start date Start date
R

RR

HI

I need to calculate a date 20 ways in the future but not including Sat, Sun
or Bank Holidays. i.e. received 01/05/09 calculated date should be 1/6/09
(date received is day 1).

Can anyone help please
 
HI

I need to calculate a date 20 ways in the future but not including Sat, Sun
or Bank Holidays. i.e. received 01/05/09 calculated date should be 1/6/09
(date received is day 1).

Can anyone help please
Click to expand...

Look at HELP for the WORKDAY function.
--ron
 
Use the WORKDAY() function for this. If not available currently, you may
need to go Tools > Add Ins... > Analysis Toolpak to see it.
 
Use the WORKDAY() function for this. If not available currently, you may
need to go Tools > Add Ins... > Analysis Toolpak to see it.
 
Back
Top