LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Computing days between TODAY() and older date in a cell

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF for numbers of dates in column which are 30 days older than today [email protected] Excel Worksheet Functions 4 April 3rd 23 02:39 PM
how do i highlight a date that is 4+ days old in excel? Picodillo Excel Worksheet Functions 3 October 23rd 06 06:43 PM
How do I add a range by date over 90 days older than today John DeLosa Excel Discussion (Misc queries) 4 February 16th 06 09:30 PM
Date Format Problems?? nastech Excel Discussion (Misc queries) 5 November 14th 05 01:53 AM
How do I show dates older than present date? Sissyfirst Excel Worksheet Functions 1 July 12th 05 09:56 PM


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"