AGING
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.
|