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
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
How do I edit the raw HTML of an email in Outlook 2003? 6
How do I make "today" more visible in Monthly View? 3
How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE? 5
What is the max size of attachments for Outlook2003 emails... IN PRACTICE! 2
How do I change default colours and print settings for Excel2003 (WinXP) ? 1
How can I paste WITHOUT cell references changing (and without usingabsolute cell addresses) [EXCEL20 8

Top