ExcelBanter - DAYS360

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - DAYS360 (https://www.excelbanter.com/excel-worksheet-functions/124359-days360.html)

Trouvera52

DAYS360

I don't understand why I'm getting the following result:

DAYS360(A5,TODAY())

when A5 = 12/13/2006

Result = 19-Jan-00

I have also used the date format 13-Dec-06 and receive the same result.
Thanks in advance,
Trouvera

Trouvera52

DAYS360

Oops -- the format of the result needs to be numeric.

"Trouvera52" wrote:

I don't understand why I'm getting the following result:

DAYS360(A5,TODAY())

when A5 = 12/13/2006

Result = 19-Jan-00

I have also used the date format 13-Dec-06 and receive the same result.
Thanks in advance,
Trouvera

All times are GMT +1. The time now is 04:30 PM.