Counting how many days since last accident occured on the job
Thank you Dave for your help! It works really well
"Dave Peterson" wrote:
Just subtract the date of the last accident from today's date and format the
cell as general.
Maybe something like:
=today()-max(a:a)
And format as general.
aussiegirlone wrote:
Dear someone, I am trying to calculate the number of days since the last
accident that occured on the job using a formular. column (A) is the date, &
column (B) is the accidents. Does anyone know a formular that would calculate
when the last accident occured e.g. 157 days ago?
--
Dave Peterson
|