| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Changing value of a date by a number of calendar months
in excel is there a formula that allows me to increase a date by an exact
number of calendar months? e.g., I want to increase the date of 28-Feb-2006 by 3 calendar months to 28-May-2006 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - Changing value of a date by a number of calendar months
Maybe...
=date(year(a1),month(a1)+3,day(a1)) But this may cause trouble when the dates are near the end of the month (Aug 30 & 31 would go to what date? Sunny wrote: in excel is there a formula that allows me to increase a date by an exact number of calendar months? e.g., I want to increase the date of 28-Feb-2006 by 3 calendar months to 28-May-2006 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - Changing value of a date by a number of calendar month
Thanks - Just what I was looking for. The problem as you mentioned is minor
(also happens for Feb 29 and leap years!) and when it happens it returns the next 'real' day. regards. "Dave Peterson" wrote: Maybe... =date(year(a1),month(a1)+3,day(a1)) But this may cause trouble when the dates are near the end of the month (Aug 30 & 31 would go to what date? Sunny wrote: in excel is there a formula that allows me to increase a date by an exact number of calendar months? e.g., I want to increase the date of 28-Feb-2006 by 3 calendar months to 28-May-2006 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have a calendar pop up in a cell to pick & insert a date in excel | Excel Worksheet Functions | |||
| Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
| Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Hybrid Mode
