Computing days between TODAY() and older date in a cell

[Guest]

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.

 

[Niek Otten]

=TODAY()-G14, then format as General or Number

Look here:

http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[Guest]

=DATEDIF(G14,TODAY(),"y") & " years, " & DATEDIF(G14,TODAY(),"ym") & "
months, " & DATEDIF(G14,TODAY(),"md") & " days"

 

[Guest]

Got it! DATEDIF() at cpearson.com/excel... DATEDIF(G14,TODAY(),"d") does
exactly what I need. I'll definitely bookmark this website looks like it
could be very helpful.

THANKS!