View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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