Hi How do I add (say 13) working days to an existing date? With thanks Ship Shiperton Henethe
S ship Aug 5, 2008 #1 Hi How do I add (say 13) working days to an existing date? With thanks Ship Shiperton Henethe
J John C Aug 5, 2008 #2 Assuming your existing date is an actual date (i.e.: not formatted as text). A1: existing date A2: =A1+13
Assuming your existing date is an actual date (i.e.: not formatted as text). A1: existing date A2: =A1+13
P Peo Sjoblom Aug 5, 2008 #3 =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
=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
J John C Aug 5, 2008 #4 ignore my post -- John C John C said: Assuming your existing date is an actual date (i.e.: not formatted as text). A1: existing date A2: =A1+13 Click to expand...
ignore my post -- John C John C said: Assuming your existing date is an actual date (i.e.: not formatted as text). A1: existing date A2: =A1+13 Click to expand...
