Solved Compute monthly date formula

March 9, 2012 at 20:02:40
Specs: Windows XP
I am trying to create a spreadsheet that will automatically calculate the 1st day of the month in the column A. Column B is the payment amount. Column C is the balance remaining. I am using the following formula:

A1 + 30

The problem is, say March which have 31 days. It gives a return in Column A of 3/1/2012, then 3/31/2012. I want 3/1/2012 then 4/1/2012. Also, February goes from 2/1/2012 to 3/3/2012. Please help me fix this. Thank you.

See More: Compute monthly date formula

Report •

March 9, 2012 at 20:59:20
In the time it took you to post your question you could have manually entered each date. :-)

Enter 1/1/2012 in A1
Enter 2/1/2012 in A2
Select A1:A2
Grab the auto-fill handle and drag it down as far as you need.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

March 10, 2012 at 19:54:02

I did just that before posting this question and it is not going in sequence as you mention, 1/1/2012, 2/1/2012 which is due to the fact that some months have more days in it than others.

Insult Deleted By Moderator

Report •

March 11, 2012 at 01:30:55
✔ Best Answer
If you continue to use that attitude in this forum, I will remove every one of your posts and have your membership cancelled.

As moderator of this forum, I have edited your post to remove the insult.

The suggestion I offered works perfectly fine because Excel knows enough to increment the month but hold the day constant. Continue to drag the dates down for more than 12 months and the month will return to 1 but the year will increment. The day will remain constant at 1.

This list was created using the process I offered above and was copied directly from an Excel spreadsheet:


From where I am sitting, I can't see what you are doing wrong, but if you follow the instructions I offered, you will have a list of dates that all start at the first of the month. Just for fun, try starting with 10/29/2012 and drag it past February 2013. Watch how smart Excel is when it comes to Leap Years.

Feel free to apologize whenever you are ready.

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

March 11, 2012 at 08:25:38
My apologies

Report •

Ask Question