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.