Hi,
On my Appointments sheet I have listed 0,12, or 1 for Repeat Months. If the event is a "0" then it doesn't repeat but if it's a number "1" it only occurs once each year and if it's a "12" it repeats every month. These events will show up on the Monthly Analysis sheet by selecting the proper month in cell F1 on that sheet.
I am trying derive the formulas in column F on the appointments sheet but am having trouble.
Can someone please help me?
Thank you
On my Appointments sheet I have listed 0,12, or 1 for Repeat Months. If the event is a "0" then it doesn't repeat but if it's a number "1" it only occurs once each year and if it's a "12" it repeats every month. These events will show up on the Monthly Analysis sheet by selecting the proper month in cell F1 on that sheet.
I am trying derive the formulas in column F on the appointments sheet but am having trouble.
Can someone please help me?
Thank you