=TODAY()-G14, then format as General or Number
Look he
http://www.cpearson.com/excel/datetime.htm#AddingDates
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Big UT Fan" wrote in message ...
| 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.