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

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

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

On Tue, 26 May 2009 05:12:02 -0700, RR wrote:

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

Look at HELP for the WORKDAY function.
--ron

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

Use the WORKDAY() function for this. If not available currently, you may
need to go Tools Add Ins... Analysis Toolpak to see it.

"RR" wrote:

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