View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default How do I add (say 13) working days to an existing date?

=WORKDAY(A1,13)

Where A1 holds the date

Read up on WORKDAY in help, it is part of the Analysis ToolPak that comes
with Excel/Office and you can set public holidays for instance in a range of
cell and include that range

--


Regards,


Peo Sjoblom

"ship" wrote in message
...
Hi

How do I add (say 13) working days to an existing date?

With thanks


Ship
Shiperton Henethe