Hi,

i have a formula that's located in sheet named "test":
=IFERROR(INDEX(Week1!N3:N89,MATCH("test",Week1!M3:M89,0)),"none")
it takes the date of the day (the bold cell) if in that day the word test is found.

in the current situation i need to copy and change this formula to the current week, because everyweek have its own sheet.
how do i make it work for all the weeks?
i mean that the code is checking for the sheets starting with the word week, then searching in the column for the word "test" then if its true it will paste the date in the cell at the test sheet.

Thanks for your help!