Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding months to date at end of month
Hi,
I have searched but can't see this specific question. Basically the question is how to add moths to a date, i need to have a column that has column F's dates + 10 months. However, the column F dates are all month end days, so 31/8/07 or 28/02/06 or 30/06/07. I have tried the edate function and also tried date(year(f),month(f)+10, day(f)) formula, but both gives 28/12/07 if the figure in the original column was February. Is there a way of rounding the date up or down to the last day of the month? Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding months to a date | Excel Worksheet Functions | |||
Adding 6 Months to a Date | Excel Worksheet Functions | |||
Count months away betwwen a strat and end date by month | Excel Worksheet Functions | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Adding 6 months to any given date | New Users to Excel |