| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add month to date
If you have the analysis toolpak addin installed you can try:
=EDATE(A1,1) Hope this helps Rowan oomyoo wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add month to date
On Thu, 1 Dec 2005 15:16:02 -0800, oomyoo
wrote: 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? =EDATE(A1,1) The EDATE function is in the Analysis ToolPak. If you get a #NAME error, see HELP for that function for instructions how to install it. --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add month to date
Thanks very much!
"Ron Rosenfeld" wrote: On Thu, 1 Dec 2005 15:16:02 -0800, oomyoo wrote: 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? =EDATE(A1,1) The EDATE function is in the Analysis ToolPak. If you get a #NAME error, see HELP for that function for instructions how to install it. --ron |
| Reply |
| 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 | |||
Linear Mode
