| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date calculations
In my spreadsheet I have a column of the date in which we purchased
particular items. In another column, I would like to have a formula that tells me as of today, how old that item is. For example, let's say I purchased something 5/24/01, that date is listed in column A. I would like my formula to be something like =Today() - A1. This would then tell me it equals 5 years or 5.4 if it was 5 years and so many months, etc. My formula does not give me the answer I am expecting, it gives me a date. How should I be entering this formula to get the results I need? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Date calculations and sum | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Setting up "Year to Date" Calculations in a Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
