View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Computing days between TODAY() and older date in a cell

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