How Many Days Since... Formula -Help

  • Thread starter Thread starter ScottyG
  • Start date Start date
S

ScottyG

Hi, can anyone help?
I have a spreadsheet tracking several different Departments in our
company and how often they have an accident. I need to track how many
days they go without an accident.
So if Dept A had their latest accident yesterday. And if someone opens
the spreadsheet in 3 days, it should say "4 days w/o an accident for
Dept A.

I'm sure this can be done, I just have no idea how :roll:

Thanks in advance,

Scotty
 
Assuming 8/5/2003 is the start date...

=TODAY()-"8/8/2003"&" Days w/o an accident for Dept A"

Lance
 
Back
Top