How to calculate amount of days between current date and another date

[Lmaonade]

Hi guys,

I am wanting to work out how many days between the current date (whenever I open the spreadsheet) and another fixed date in the spreadsheet. I'm not sure how to do this. Whether it uses the =TODAY function etc.

Any help would be appreciated.

 

[FormR]

Hi, simply =TODAY()-FixedDate or =FixedDate-Today() depending on what you want.