Date Formuli

[spike1947]

Hi

Thanks for letting me join your forum ,I had been on this forum quite a long time ago forgot my password and my old email address no longer exists , any way to the point , I have not used the excel date function for quite a while , I don't seem to be able to get the =360 days between 2 dates to work , I thought I had it , and in the formula bar it says the correct days but the result in the spreadsheet is a date , I have attached a screen shot to show you .

Cheers

Spike

[etaf]

Click on the cell and change the format of that cell from a Date to a Number or General

Its trying to convert the result number into a date

[spike1947]

Hi Wayne

Thanks for that , have a nice day .

cheers

Spike

[etaf]

your welcome, thanks for the rep