just want know the formula in computing the age of an event by getting the
difference between a certain date to current date by not inputting the
current date. I'll use this in my work for monitoring the ages of ALARMS
until these are resolved.

Use DATEDIF()
A1 = Date

=DATEDIF(A1,TODAY(),"y") to return difference in years
=DATEDIF(A1,TODAY(),"m") to reutrn difference in months
=DATEDIF(A1,TODAY(),"d") to return the days

If this post helps click Yes
---------------
Jacob Skaria


"Phillip" wrote:

just want know the formula in computing the age of an event by getting the
difference between a certain date to current date by not inputting the
current date. I'll use this in my work for monitoring the ages of ALARMS
until these are resolved.

Or instead of =DATEDIF(A1,TODAY(),"d") you can use =TODAY()-A1
--
David Biddulph

"Jacob Skaria" wrote in message
...
Use DATEDIF()
A1 = Date

=DATEDIF(A1,TODAY(),"y") to return difference in years
=DATEDIF(A1,TODAY(),"m") to reutrn difference in months
=DATEDIF(A1,TODAY(),"d") to return the days

If this post helps click Yes
---------------
Jacob Skaria


"Phillip" wrote:

just want know the formula in computing the age of an event by getting
the
difference between a certain date to current date by not inputting the
current date. I'll use this in my work for monitoring the ages of ALARMS
until these are resolved.