start date - current date = xdays 1

[leewisener]

What I want to do is take a date in one column and have it calculate the number of days that have elapsed up to the current date.

Can anyone help me with that?

Thanks

Lee

 

[lupins46]

= today() - A1
or whatever

fornmat the result as a number

 

[leewisener]

Great thanks, that did the job exactly.