00:00If you want to create a monthly reoccurring schedule with adjustable frequency that looks
00:04something like this, this is how you do it.
00:07You start off first by finding the cell numbers location here on this whole data set.
00:11To do that, you're going to use a function called row, open parenthesis and select this
00:15cell here.
00:16You're going to press F4 three times like this so that your column is fixed while your
00:21row is variable.
00:23Close parenthesis, subtract column and then after that in there, we're going to use this
00:29as an argument and press F4 twice like this so that your row is fixed but your column
00:35is variable.
00:36Close parenthesis and hit enter.
00:38And if you look at this, this is basically a date itself if you stretch this further.
00:42You can see it's showing 1st January 1900.
00:45To convert this into a number, you press control one by selecting this cell here and go numbers
00:50and go general and then click OK.
00:53As you can see, this shows a number one.
00:55I'm going to apply the rest of the rows like this and it should have a running
00:59number like this.
01:00Now we can use this number to get the modulus of this number so that it will equal to zero
01:06when it's divisible by three.
01:07Let me show you what I mean by that.
01:08You go into the formula here and then you encapsulate the row and the column function
01:13with a function called mod and the first argument would be the row and subtract column and the
01:20second argument would be this frequency itself.
01:24Over here, you're going to try to make the row fixed by pressing F4 two times like this
01:29so that your particular row number two is fixed but your column is variable because you're
01:35going to have to use for the rest of the column.
01:37Close parenthesis and hit enter.
01:39As you can see, if you were to drag to a few rows, you can see that every time is day
01:44number three is zero.
01:46Now we can use this modulus zero to our advantage by using an if statement here.
01:52You're going to say if, open parenthesis, if the result of modulus is zero like this,
02:01basically we're going to say booked, which means you want to book that day for this example
02:06will be running.
02:08And then if it's not zero, we're going to basically leave it blank.
02:11Close parenthesis and hit enter.
02:14Now if you try to apply the same formula to the rest of the row, you can see every third
02:17day it is showing as booked.
02:21Let's make the solution a bit hardy by encapsulating the if statement with if error.
02:27And the first argument on if error will be the if statement itself.
02:30If that is an error, we're basically going to show blank here.
02:33And this is good because sometimes if you have a dodgy date here, this if error will take
02:37care of it instead of showing an error.
02:40So basically it looks like there's nothing really changed.
02:42Next I'm going to apply to the rest of the columns like this.
02:45I'm going to adjust this column a bit like that.
02:48And then now apply to the rest of the row like this.
02:54And then you're scheduling is done.
02:56And then you're scheduling is done.
02:57And then you're scheduling is done.
