I am trying to put a task rota together; This includes Daily and weekly tasks (those only done once a week)
Rather than have to manually update who is assigned on a weekly basis I put together a table which basically performs a VLOOKUP and looks at the Thursday of each week, I have the formula:
Where the function =TODAY() is in cell F1, Whilst this works, my question is, is there a way of replacing the F1 reference with the TODAY function in the formula directly?
I tried just changing it which didn’t work and I appreciate I’m probably using a convoluted way of doing something very simple.
Thanks in advance for any help.