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

Hi

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

With thanks


Ship
Shiperton Henethe

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

Assuming your existing date is an actual date (i.e.: not formatted as text).
A1: existing date
A2: =A1+13
--
John C


"ship" wrote:

Hi

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

With thanks


Ship
Shiperton Henethe

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

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

ignore my post
--
John C


"John C" wrote:

Assuming your existing date is an actual date (i.e.: not formatted as text).
A1: existing date
A2: =A1+13
--
John C


"ship" wrote:

Hi

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

With thanks


Ship
Shiperton Henethe