looking for Excel/VBA macro to use "+" to increase a date in a cell by one day - like in Quicken'

New Contributor

I'm a programming novice.  Have spent a couple of days trying to accomplish this.  Would be extremely handy.

3 Replies


Here is an example code with an example file to try out.


Sub dateplusone()
ActiveCell.Value = ActiveCell.Value + 1
End Sub



I would be happy to know if I could help.



I know I don't know anything (Socrates)


Was the answer useful? Mark them as helpful!

This will help all forum participants.


Too Simple!  Thanks.  Problem was I was trying to test field type and keystroke: all I had to do was let the macro assign the keystroke with Ctrl+letter.  Also made a similar macro to subtract a day.


With your permission, if I may recommend that you read this link carefully for your future questions.

The information in the Link will help you to get a proposal solution quickly and precisely.


 Welcome to your Excel discussion space!

If you are looking to ask a question or start a conversation about Excel, you are in the right place!  Ask away.


Thank you for your understanding and patience



I know I don't know anything (Socrates)