| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF for numbers of dates in column which are 30 days older than today | Excel Worksheet Functions | |||
| how do i highlight a date that is 4+ days old in excel? | Excel Worksheet Functions | |||
| How do I add a range by date over 90 days older than today | Excel Discussion (Misc queries) | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| How do I show dates older than present date? | Excel Worksheet Functions | |||
Threaded Mode
