help using dates

[jamesg2166]

i am trying to set up a report for my bussiness. on the report i need to keep track of the number of days without a injury. i would like to add a cell that keeps a running count. example, i have had 10 days without a injury i would like the cell to keep adding the days up as the days go by. i would like it to keep a running count for me. all this will be on one page. thanks

 

[barry houdini]

If the date of the last injury is in A1

=TODAY()-A1

 

[jamesg2166]

that didnt work. i would like te answer to be in number of days. the number of days sence last injury15 days.

 

[Brian from Maui]

that didnt work. i would like te answer to be in number of days. the number of days sence last injury15 days.

Format the cell that houses Barry's formula as a Number or General.

 

[barry houdini]

...or

=TODAY()-A1&" days"