| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| working out days between date. | Excel Worksheet Functions | |||
| Want to calculate 3 business days from a certain existing date | Excel Discussion (Misc queries) | |||
| Can Excel add working days to a date to result in another date? | Excel Worksheet Functions | |||
| How do you add 40 working days to a date | Excel Discussion (Misc queries) | |||
| date (minus) date = working days diff | Excel Discussion (Misc queries) | |||
Linear Mode
