(Msg. 1) Posted: Tue Aug 05, 2008 7:38 am
Post subject: How do I add (say 13) working days to an existing date? Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Hi
How do I add (say 13) working days to an existing date?
(Msg. 2) Posted: Tue Aug 05, 2008 7:49 am
Post subject: RE: How do I add (say 13) working days to an existing date? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>
(Msg. 3) Posted: Tue Aug 05, 2008 8:10 am
Post subject: Re: How do I add (say 13) working days to an existing date? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=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" <shiphen RemoveThis @gmail.com> wrote in message
news:90cad5a5-c25f-4d95-865c-298d3479cb29@t54g2000hsg.googlegroups.com...
> Hi
>
> How do I add (say 13) working days to an existing date?
>
> With thanks
>
>
> Ship
> Shiperton Henethe
(Msg. 4) Posted: Tue Aug 05, 2008 8:20 am
Post subject: RE: How do I add (say 13) working days to an existing date? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
> >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office