Re: WORKDAY returns too late a date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <mskabialka@xxxxxxxxxxxxx> wrote in message
news:OoXrTKWiFHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>
>
>


.

Relevant Pages

  • A little help with time calculations
    ... subtract to this. ... my only problem is that once the user inputs the time ... and the correction its adding it like it was 100 not to 60 any help? ... Prev by Date: ...
    (comp.lang.python)
  • Re: stitch-counting gadget
    ... You would have to be a serious gadget-geek to use one of ... And I'll bet it doesn't know how to subtract when the you're ... Prev by Date: ...
    (rec.crafts.textiles.yarn)
  • Re: How many 3-digit positive integrs are odd and do not contain the digit "5"?
    ... > I was thinking to get all the possible numbers and then subtract the ... by inclusion-exclusion, the total number that have a 5 or are odd is: ... Prev by Date: ...
    (sci.math)
  • Re: Calculating number of Saturdays in a Year
    ... Using DAYSwill potentially undercount your Saturdays (as well as ... Whether to subtract one or not depends on the OP's interpretation of ... > Change the reference of A1 and A2 to fit your data. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: WORKDAY returns too late a date
    ... though is a little inconsistent when I include a range of ... > WORKDAY calculates a date based on a simple date difference. ... >> I also have a range of holidays in the formula but that is not an issue ...
    (microsoft.public.excel)