| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add month to date
I'm trying to do a similar thing, but instead of adding a month to show the
month and year, i need to show month/day/year. And another problem is I'm trying to add a month to the last day of the month. I tried the date(year(A1),month(A1)+1,day(A1)) but it doesn't seem to work when adding a month to the last day of the month. any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
| Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. | Excel Discussion (Misc queries) | |||
| enter month end date | Excel Worksheet Functions | |||
| Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
