Date on each side, there is a button on the left is last month, on the right is the next month, how can achieve much forward check it last month for a month, click next month will turn back for a month, the date format for "in May 2014," can show only the year and month, because want substracting the specified date of the inside of the cell, I specify the cell is to use formula "today ()," said, hope ace to give me a fool, it is best to copy the code can be, I don't have the basis of this, thank you!
In December of this year, according to the next month can turn over to the next year on January,

CodePudding user response:

The format (dateadd (" M ", 1, now), "yyyy - MM")
If it is a month, add 1