Counting how many days since last accident occured on the job

[aussiegirlone]

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?

 

[Mike H]

Hi,

With the date of your last accident in b1 try this

=DATEDIF(B1,TODAY(),"d")

Mike

 

[Dave Peterson]

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]

Thank you so very much for your help Mike
However, as I still need to be able to combine both the accident with the
date, (which I dont know how to do either,) Would the edited formular below
be ok?
=DATEDIF(H33*B33,TODAY(),"d")

 

[aussiegirlone]

Thank you Dave for your help! It works really well

 

[Mike H]

Hi,

What is in those 2 cells

H33 = ?
B33 = ?

Mike

 

[David Biddulph]

Why not =TODAY()-B1 ?
What extra value does DATEDIF give, if you are dealing in days?

 

[aussiegirlone]

Dear Mike
B is the dates Column, H are the accidents column, therefore B33, = dates
and H33 = accidents. Your formular works very well as does the formular Dave
Peterson gave. Both work very well even by me modifying them.

=DATEDIF(H33*B33,TODAY(),"d")
=TODAY()-MAX(B:B,H:H)

 

[Mike H]

David,

No added value. I simply like Datedif so tend to offer it as a solution
because I think it's quite intuative for posters to recognise exactly what's
going on.

Mike

 

[aussiegirlone]

Hello David
It is good to know that there is so much help available, and each one of you
that has responded, have given me a very good formular to work with, as each
one works well. Thank you kindly for your help!

 

[Chip Pearson]

because I think it's quite intuative for posters to recognise exactly what's
going on.

True enough, but it might be worth mentioning that DATEDIF isn't
documented in the Excel help files to prevent users from wasting time
trying to track it down.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[IanB]

David,

No added value. I simply like Datedif so tend to offer it as a solution
because I think it's quite intuative for posters to recognise exactly what's
going on.

Mike

Hi Mike, just reading through this very old thread - is there an amended formula that would consider the information in 3 columns? Namely: date of last injury, type of injury (column has a drop down with these options (Fist Aid, Minor Injury, RIDDOR) and the department where the injury occurred. Any assistance would be appreciated.