Re: DAYS360 Function Problem
From: JohnI in Brisbane (john.iseppi_at_anet.spamfooler.au)
Date: 09/18/04
- Next message: Don: "Re: Rename a Workbook??"
- Previous message: shadylady_at_att.net: "Excel Functions"
- In reply to: andyp161: "DAYS360 Function Problem"
- Next in thread: Myrna Larson: "Re: DAYS360 Function Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 19 Sep 2004 06:04:36 +1000
andyp161,
Try this
=IF(B2="","",DAYS360(A2,B2))
regards,
JohnI
"andyp161" <andyp161.1csoly@excelforum-nospam.com> wrote in message
news:andyp161.1csoly@excelforum-nospam.com...
>
> Hi there,
>
> In column A I have start dates, in column B completion dates, and in
> column C the DAYS360 function in order to calculate time taken.
> However, the work*** is ongoing and therefore the start date is
> entered days/months before the completion date. As a result, where I
> have entered a start date and not a completion date, the DAYS360
> function is returning negative numbers which I do not want. Is there
> anyway that I can instruct the DAYS360 function in column C not to
> activate until the completion date is entered in column B?
>
> Many thanks
>
> Andy
>
>
> --
> andyp161
> ------------------------------------------------------------------------
> andyp161's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=11654
> View this thread: http://www.excelforum.com/showthread.php?threadid=261313
>
- Next message: Don: "Re: Rename a Workbook??"
- Previous message: shadylady_at_att.net: "Excel Functions"
- In reply to: andyp161: "DAYS360 Function Problem"
- Next in thread: Myrna Larson: "Re: DAYS360 Function Problem"
- Messages sorted by: [ date ] [ thread ]
