DAYS360 Function Problem

[andyp161]

Hi there,

In column A I have start dates, in column B completion dates, and i
column C the DAYS360 function in order to calculate time taken.
However, the worksheet is ongoing and therefore the start date i
entered days/months before the completion date. As a result, where
have entered a start date and not a completion date, the DAYS36
function is returning negative numbers which I do not want. Is ther
anyway that I can instruct the DAYS360 function in column C not t
activate until the completion date is entered in column B?

Many thanks

And

 

[JohnI in Brisbane]

andyp161,

Try this

=IF(B2="","",DAYS360(A2,B2))

regards,

JohnI

 

[Myrna Larson]

Are you SURE you want DAYS360? That is a specialized function used in the
financial sector to simplify calculations for bonds. It assumes a 360 day
year, with 12 months of 30 days each. If you really want actual days, you'll
lose 6 days each year. You can calculate the number of days between two dates
by simple subtract, i.e. =IF(ISBLANK(B2),"",B2-A2)

 

[Myrna Larson]

Typo: Should have "lose 5 (or 6) days each year"

Are you SURE you want DAYS360? That is a specialized function used in the
financial sector to simplify calculations for bonds. It assumes a 360 day
year, with 12 months of 30 days each. If you really want actual days, you'll
lose 6 days each year. You can calculate the number of days between two dates
by simple subtract, i.e. =IF(ISBLANK(B2),"",B2-A2)