View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Computing days between TODAY() and older date in a cell

=DATEDIF(G14,TODAY(),"y") & " years, " & DATEDIF(G14,TODAY(),"ym") & "
months, " & DATEDIF(G14,TODAY(),"md") & " days"
--
Gary's Student


"Big UT Fan" wrote:

Trying to compute an "age" based off of a date in a cell, where age should be
equal to TODAY-G14. The contents of G14 would be 07/04/2006 (a past date)
for instance.
Tried this and various permutations =(TODAY())-(G14)); =(TODAY()-G14), ...

Also, if you are aware of a good source for examples of using functions in
useful ways that would be much appreciated?

Thanks for your help.