test_man2
New Member
- Joined
- Aug 28, 2007
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
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.
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.