Formula subtracting months from a set date
Thanks! This did work!!!!
--
--coastal
"David Biddulph" wrote:
=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months"
assuming that your dates really are numbers formatted as Excel dates, and
aren't text looking like dates.
--
David Biddulph
"coastal" wrote in message
...
I have a row of dates and I need a formula to tell me the age in years and
months of each client.
So I have
12/15/99
7/13/02
10/14/97
and Need ages from current date.
--coastal
|