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?

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?

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

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")
"Mike H" wrote:

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

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
>

Hi,

What is in those 2 cells

H33 = ?
B33 = ?

Mike

"aussiegirlone" wrote:

> 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")
> "Mike H" wrote:
>
> > 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?

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

"Mike H" <(E-Mail Removed)> wrote in message
news10ECCD8-D751-40D3-8A7D-(E-Mail Removed)...
> 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?

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" wrote:

> Hi,
>
> What is in those 2 cells
>
> H33 = ?
> B33 = ?
>
> Mike
>
> "aussiegirlone" wrote:
>
> > 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")
> > "Mike H" wrote:
> >
> > > 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?

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" <(E-Mail Removed)> wrote in message
> news10ECCD8-D751-40D3-8A7D-(E-Mail Removed)...
> > 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?
>
>
>

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" <(E-Mail Removed)> wrote in message
> news10ECCD8-D751-40D3-8A7D-(E-Mail Removed)...
> > 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?
>
>
>