That makes somewhere between little sense and no sense.
Bear in mind that none of us can see your screen or read your mind, we can only work with what you give us.
In Post 1, the formula refers to row 12 only. In post 2 you refer to V13, W13, etc. Does this mean that it is spread over 2 rows, or should it be V12, W12, etc?
In Post 1, you mention 'ROW AB1'. AB1 is not a row. 1 is a ROW, AB is a column, AB1 is a cell. Incorrect descriptions will get you incorrect answers. You do the same with ROW A1 in post2.
At minimum, you will need to provide 2 or 3 accurate examples of where the week and day references are, and what the expected result of the formula should be.
Ok i'll try again. So my spreadsheet looks something like this
| row 10 | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
| row 11 | Start | end | mon | tue | wed | thu | fri | M | T | W | T | F | M | T | W | T | F | 1 | 2 | 3 | 4 | 5 |
| row 12 | | | 1 | 2 | 3 | 4 | 5 | | | 3 | | | | | | | | | | | | |
<tbody>
</tbody>
in column E and F i have start and end dates and a formula that works for that.
Calendar dates start from column AB runs until column IH on row 10.
So if i enter start date 29/08/2019 in column E and end date in Column F 30/08/2019 a cell is filled somewhere on row 12.
in columns G through to K i have 5 cells that when you type in 1, 2, 3, 4,5 will populate recurring daily/weekly events from column AB onwards and formula that works for that.
in column L to P i have 5 cells that when clicked on populate fortnightly recurring events and a formula that works for that.
And in the same vein i'm trying to populate monthly recurring events in column q through to z.
in cells q12 if you enter 1 - you have selected monday.
in cell r12 if you enter 2 - you have selected tue
in cell s12 if you enter 3 - you have selected wed
in cell t12 if you enter 4 - you have selected thur
in cell u12 if you enter 5 - you have selected fri.
in cells v12 if you enter 1 - you have selected 1st week of month
in cell w12 if you enter 2 - you have selected 2nd week of month
in cell x12 if you enter 3 - you have selected 3rd week of month
in cell y12 if you enter 4 - you have selected 4th week of month
in cell z12 if you enter 5 - you have selected 5th week of month
the week of month numbers can be found in row 1 start in column AB through IH says in each cell whether its week 1, 2, 3, 4, or 5.
I don't know if this is possible or if there are two many variables.
