shahdelsol
Active Member
- Joined
- Jul 21, 2009
- Messages
- 276
- Office Version
- 365
- Platform
- Windows
I am using pre-made calendar template in excel that I like. There is one code in it that counts the days of the month: (=INDEX(calendar,ndx+0,daypattern) and next line is (=INDEX(calendar,ndx+1,daypattern) and goes all the way to (=INDEX(calendar,ndx+5,daypattern)
One problem with this I have is when it is done with the current month it continues to next month (usually first few days of the month) that I don't need necessarily. Is there a way that this formulas can be modified that once goes to the last day of the month, it would stop and not showing any days of next month? For your info, the name of current month is in I2 and the current year is in I3
I think the change need to be done only to last 2 rows (ndx+4 and ndx+5) because first 4 rows (ndx+0, ndx+1, ndx+2, ndx+3) are needed for all months but for certain month you need part of ndx+4 and for certain month you need part of ndx+5. I hope someone can help.
One problem with this I have is when it is done with the current month it continues to next month (usually first few days of the month) that I don't need necessarily. Is there a way that this formulas can be modified that once goes to the last day of the month, it would stop and not showing any days of next month? For your info, the name of current month is in I2 and the current year is in I3
I think the change need to be done only to last 2 rows (ndx+4 and ndx+5) because first 4 rows (ndx+0, ndx+1, ndx+2, ndx+3) are needed for all months but for certain month you need part of ndx+4 and for certain month you need part of ndx+5. I hope someone can help.