Shorten If Then formula that determines next number

[test_man2]

Greetings! I'm sure there's a simple solution, but I can't find seem to find it! I'm (still) working on a perpetual calendar but this time showing the dates of the month in rows across. I have this long convoluted formula that I'm sure can be simplified - "IF(G8=1,G8+1,IF(G8=2,G8+1,IF(G8=3,G8+1,IF(G8=4,G8+1,IF(G8=5,G8+1,IF(G8=6,G8+1," "))))))" - to determine the next number in the sequence (the first column is the month, and columns B - G have other formulas). How can I simplify this string so that it adds +1 to the number if the previous cell is one of the numbers between 1 - 6? Is there a simpler solution than saying "If(OR(G8=1, G8=2,G8=3..." etc up to G8=6?

Another issue I'm having is with determining when March begins because of Leap Year adding a day in February! I'll post that question separately later when I have time to.

 

[Joe4]

How about:

=IF(G8<=6,G8+1,...

 

[test_man2]

Well, that's simple enough! Thank you very much!

 

[Joe4]

You are welcome.
Glad I was able to help!