View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
coastal coastal is offline
external usenet poster
 
Posts: 25
Default 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