Recurrence Calendar excel

[teireii]

Hi experts,

would like to ask for your favour to create a calender showing recurrence event in monthly basis. i've created the template but i don't know how i can change the formula in tab "Calendar" to show the recurrence.

for example,
Sports - swimming class, i want to show the same item in every Sat in Calendar until 12/31/2018

School - Quiz, i want to show the same item in 17th of every month util 12/31/2018

 

[NARAYANK991]

Hi ,

Without your data layout , it is difficult to post a formula which will do what you want.

For your first requirement , you can use either the TEXT function or the WEEKDAY function to check for Saturdays.

=TEXT(date , "ddd") will return any of Mon , Tue , Wed ,..., Sat , Sun.

So you can check for :

=IF(TEXT(date , "ddd") = "Sat" ,... ,...)

The WEEKDAY function returns a value from 1 through 7 or 0 through 6 depending on a parameter ; by default , the return value is from 1 to 7 , where 1 is SUNDAY and 7 is SATURDAY.

Thus , using this function , your IF statement would be :

=IF(WEEKDAY(date) = 7 ,... ,...)

For your second requirement , you can use the DAY function to check for whether it is the 17th of any month ; the IF statement would be :

=IF(DAY(date) = 17 ,... ,...)

 

[teireii]

https://docs.google.com/spreadsheets/d/1IbafVydk2NLUIOJz-72iOg8OVkAq8FxB3Wn83AYxhSw/edit?usp=sharing

above is where i put the template...

 

[NARAYANK991]

Hi ,

You have formulae everywhere in the template ; where exactly do you want this particular formula to go ?

Mention the tab name and the cell / column / row references.