excel formula - Create rolling IF date to return live entered info as current

Question

I have a excel sheet that on the first page "dashboard" has a Weekly Value and a Quarterly Value that are pulling from a different sheet and marking weekly and quarterly goal progressions. I want to allow the first sheet to pull from the second sheet that weeks number and format green or red for on or off track. that part is simple enough. Where it gets difficult for me, is I want to only have to enter into the second page for that next week and it live update on the main sheet. So for the week of 2/1 i want to reference the second sheet that correlates to the week of 2/1. then on 2/8, i want it to refer to the week of 2/8. I'm building this for someone and want minimum work for him when i pass it on.

=IF TODAY((WEEKNUM(Appointments!F3, Appointments!F4)))

tried that but gets error

question from:https://stackoverflow.com/questions/66054548/create-rolling-if-date-to-return-live-entered-info-as-current

Answer 1

Waitting for answers