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!

"David Biddulph" wrote:

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

"Mike H" wrote in message
...
Hi,

With the date of your last accident in b1 try this

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

Mike

"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?