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

 

[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)

 

[M Skabialka]

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

 

[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