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