Hi,
I'm trying to create a repeating shift pattern (attached), I've got the format to update days/dates/months when the year is manually changed. Now I wanted to put in the 30 day repeating pattern (sheet 2) that would continue through multiple years.
I'm stuck trying to figure out how to write a formula to do this?
Less importantly I've got a repeat on March 1st when there isn't a leap year, could I hide that somehow?
TIA
I'm trying to create a repeating shift pattern (attached), I've got the format to update days/dates/months when the year is manually changed. Now I wanted to put in the 30 day repeating pattern (sheet 2) that would continue through multiple years.
I'm stuck trying to figure out how to write a formula to do this?
Less importantly I've got a repeat on March 1st when there isn't a leap year, could I hide that somehow?
TIA