| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To create formula to add 3 years and subtract 1 day from a date?
I would like to be able to create a formula for an Excel worksheet using a
list of dates and then subtracting one day and adding 3 years, 2 years, 2 years 3 months, 2 years 6 months and 3 years less 1 week to their respective columns For example, 11.10.2005 is given date Then 10.10.2008, 10.10.2007, 10.01.008 and 03.10.2008 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract a date from a date for a sum of total years? | Excel Discussion (Misc queries) | |||
| how do I subtract years and then divide | Charts and Charting in Excel | |||
| How do I subtract today's date from one before 1900? | Excel Discussion (Misc queries) | |||
| compute days between dates | Excel Worksheet Functions | |||
| Need Formula for Date Conversion | Excel Worksheet Functions | |||
Threaded Mode
