| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To work out how many days, weeks, months to I retire on 20 Sep
"Jacob Skaria" wrote: With retire date in A1 Days =DATEDIF(TODAY(),A16,"d") Weeks = =DATEDIF(TODAY(),A16,"d")/7 Month =DATEDIF(TODAY(),A16,"m") Years =DATEDIF(TODAY(),A16,"y") If this post helps click Yes --------------- Jacob Skaria "Using the date functions" wrote: Hi, thanks to any one who can help. I'm using Excell 2000 and would like to do the above in a exsisting wookbook. Sad I know, but my other hobby is digital photography, and that is takeing all my thoughts. Thanks Many Thanks Jacob. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheets dates,weeks and Months. How do I | Excel Worksheet Functions | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| A number of days into weeks and days | Excel Worksheet Functions | |||
| Group data by weeks not months | Excel Discussion (Misc queries) | |||
| How do I sort by date (not days, weeks, months) in Excel 2000? | Excel Discussion (Misc queries) | |||
![Using the date functions[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
