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)

On Fri, 21 Nov 2008 05:12:01 -0800, Mike H
wrote:

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



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