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

S

ship

Hi

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

With thanks


Ship
Shiperton Henethe
 
J

John C

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

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get Excel (2003) to return just the first 4 words (of another cell)? 3
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" 4
Function for returning quarter based on current date? 4
How do I combine 2 data sets using date? 2
How to change date format to 7 working days a week in ms project 2010? 0
Outlook 2016: recent change to add account. No browse for data file. 0
Checking for date and time overlaps 0
Export BPMN Visio Chart to Excel 0

Top