| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date list in 1 month increments
I want to enter a date in field A1 and have every field after that display the date in one month increments. So if A1 is 4/30/2006, then A2 will be 5/30/2006 etc. I've tried using [=EDATE(A1,1)] as suggested in Excel Help files, but it's returning #NAME? Not sure what I'm doing wrong? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520200 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date list in 1 month increments
You probably need to install the Analysis Toolpak. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=520200 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date list in 1 month increments
I agree with SteveG's diagnosis of the Analysis Toolpak. However, I
wonder if you don't need a slightly different solution, and here's why: when I mocked up your scenario and used EDATE with a start date of 1/30/2006 the result was 2/28/2006. The EDATE result for the following months was 3/28, 4/28 etc, not producing your desired output of 3/30, 4/30. Are you *always* trying to produce a date on the 30th of the month, or is that just an example? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date list in 1 month increments
perfect! Thanks! -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520200 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date list in 1 month increments
Well, here's the deal. I'm guessing (haven't started payments yet) that my mortgage will probably be due the same date of each month. If it's due the last day of the month, then i agree this is an issue...however, i'm totally stumped on how this might be overcome??? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520200 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date list in 1 month increments
To always return the last day of the month use EOMONTH. =EOMONTH(A1,1) Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=520200 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date list in 1 month increments
Thanks again! -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520200 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month to date calculations | Excel Worksheet Functions | |||
| Formula = Today's date + 1 month | Excel Worksheet Functions | |||
| Changing a date back one month | Excel Discussion (Misc queries) | |||
| 4 and 5 week months | Excel Discussion (Misc queries) | |||
| Round date to first of month | Excel Discussion (Misc queries) | |||
Linear Mode
