WORKDAY returns too late a date

[M Skabialka]

When I use the formula
=WORKDAY("12/5/05",4) it returns 12/9/05
and
=WORKDAY("12/5/05",5) returns 12/12/05

What I really need is a formula that will let me add 5 days (or whatever) to
a date, count that date as the first day, then return the date that would be
the 5th date.

e.g.
12/5/05, 5
12/5/05, 12/6/05, 12/7/05, 12/8/05, 12/9/05
so it should return 12/9/05, not 12/12/05
=WORKDAY("12/5/05",5)-1 returns 12/11/05, so this is not the answer.

I also have a range of holidays in the formula but that is not an issue
here.

Can anyone help me with this formula? I seldom use Excel, so this is quite
baffling to me.

Thanks,
Mich

[Bob Phillips]

Do you mean ="12/05/2005"+5+1

--
HTH

Bob Phillips

"M Skabialka" <[email protected]> wrote in message
news:[email protected]...
> When I use the formula
> =WORKDAY("12/5/05",4) it returns 12/9/05
> and
> =WORKDAY("12/5/05",5) returns 12/12/05
>
> What I really need is a formula that will let me add 5 days (or whatever)
to
> a date, count that date as the first day, then return the date that would
be
> the 5th date.
>
> e.g.
> 12/5/05, 5
> 12/5/05, 12/6/05, 12/7/05, 12/8/05, 12/9/05
> so it should return 12/9/05, not 12/12/05
> =WORKDAY("12/5/05",5)-1 returns 12/11/05, so this is not the answer.
>
> I also have a range of holidays in the formula but that is not an issue
> here.
>
> Can anyone help me with this formula? I seldom use Excel, so this is
quite
> baffling to me.
>
> Thanks,
> Mich
>
>
>
>

[Earl Kiosterud]

Mich,

WORKDAY calculates a date based on a simple date difference. For example
WORKDAY(7/1, 1) would yield 7/2 (I've left out the formula semantics). But
you want to give it inclusive dates, not simple difference dates. So just
subtract 1 from your inclusive count).

=WORKDAY("12/5/05", 5-1)
--
Earl Kiosterud
www.smokeylake.com

"M Skabialka" <[email protected]> wrote in message
news:[email protected]...
> When I use the formula
> =WORKDAY("12/5/05",4) it returns 12/9/05
> and
> =WORKDAY("12/5/05",5) returns 12/12/05
>
> What I really need is a formula that will let me add 5 days (or whatever)
> to a date, count that date as the first day, then return the date that
> would be the 5th date.
>
> e.g.
> 12/5/05, 5
> 12/5/05, 12/6/05, 12/7/05, 12/8/05, 12/9/05
> so it should return 12/9/05, not 12/12/05
> =WORKDAY("12/5/05",5)-1 returns 12/11/05, so this is not the answer.
>
> I also have a range of holidays in the formula but that is not an issue
> here.
>
> Can anyone help me with this formula? I seldom use Excel, so this is
> quite baffling to me.
>
> Thanks,
> Mich
>
>
>
>

[M Skabialka]

This works better, though is a little inconsistent when I include a range of
holidays.
Thanks

"Earl Kiosterud" <[email protected]> wrote in message
news:[email protected]...
> Mich,
>
> WORKDAY calculates a date based on a simple date difference. For example
> WORKDAY(7/1, 1) would yield 7/2 (I've left out the formula semantics).
> But you want to give it inclusive dates, not simple difference dates. So
> just subtract 1 from your inclusive count).
>
> =WORKDAY("12/5/05", 5-1)
> --
> Earl Kiosterud
> www.smokeylake.com
>
> "M Skabialka" <[email protected]> wrote in message
> news:[email protected]...
>> When I use the formula
>> =WORKDAY("12/5/05",4) it returns 12/9/05
>> and
>> =WORKDAY("12/5/05",5) returns 12/12/05
>>
>> What I really need is a formula that will let me add 5 days (or whatever)
>> to a date, count that date as the first day, then return the date that
>> would be the 5th date.
>>
>> e.g.
>> 12/5/05, 5
>> 12/5/05, 12/6/05, 12/7/05, 12/8/05, 12/9/05
>> so it should return 12/9/05, not 12/12/05
>> =WORKDAY("12/5/05",5)-1 returns 12/11/05, so this is not the answer.
>>
>> I also have a range of holidays in the formula but that is not an issue
>> here.
>>
>> Can anyone help me with this formula? I seldom use Excel, so this is
>> quite baffling to me.
>>
>> Thanks,
>> Mich
>>
>>
>>
>>
>
>

[Earl Kiosterud]

Mich,

Does the holiday range have anything to do with subtracting 1 for an
inclusive date range? I get the following. Seems right.

=WORKDAY("12/5/05",20-1) yields 12/30/05
=WORKDAY("12/5/05",20-1,"12/6/05") yields 1/2/06
=WORKDAY("12/5/05",20-1,{"12/6/05","12/7/05"}) yields 1/3/06
--
Earl Kiosterud
www.smokeylake.com

"M Skabialka" <[email protected]> wrote in message
news:%[email protected]...
> This works better, though is a little inconsistent when I include a range
> of holidays.
> Thanks
>
> "Earl Kiosterud" <[email protected]> wrote in message
> news:[email protected]...
>> Mich,
>>
>> WORKDAY calculates a date based on a simple date difference. For example
>> WORKDAY(7/1, 1) would yield 7/2 (I've left out the formula semantics).
>> But you want to give it inclusive dates, not simple difference dates. So
>> just subtract 1 from your inclusive count).
>>
>> =WORKDAY("12/5/05", 5-1)
>> --
>> Earl Kiosterud
>> www.smokeylake.com
>>
>> "M Skabialka" <[email protected]> wrote in message
>> news:[email protected]...
>>> When I use the formula
>>> =WORKDAY("12/5/05",4) it returns 12/9/05
>>> and
>>> =WORKDAY("12/5/05",5) returns 12/12/05
>>>
>>> What I really need is a formula that will let me add 5 days (or
>>> whatever) to a date, count that date as the first day, then return the
>>> date that would be the 5th date.
>>>
>>> e.g.
>>> 12/5/05, 5
>>> 12/5/05, 12/6/05, 12/7/05, 12/8/05, 12/9/05
>>> so it should return 12/9/05, not 12/12/05
>>> =WORKDAY("12/5/05",5)-1 returns 12/11/05, so this is not the answer.
>>>
>>> I also have a range of holidays in the formula but that is not an issue
>>> here.
>>>
>>> Can anyone help me with this formula? I seldom use Excel, so this is
>>> quite baffling to me.
>>>
>>> Thanks,
>>> Mich
>>>
>>>
>>>
>>>
>>
>>
>
>