| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Computing days between TODAY() and older date in a cell
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! "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. |
| Reply |
| 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 | |||
Linear Mode
