Date formula returns 1902?

[PipRon7]

Hi,

I am just doing a quick date formula to find an invoice date.

Basically I have the Due Date in column A1 and in B1 I have the formula ... TODAY()-A1 ... but this returns 22/01/1900?


Can anyone explain a quick fix for this? What am I doing wrong??

Thanks in advance for any help.

 

[Redwolfx]

Change the Format to General