Sum Duration by Weeknumber
I have the following columns that pertain to my formula:
Week Target - has a number (no formula that represents the target week of the year)
Duration (minutes) - this has how many minutes each task will take.
I want to create 3 sheet summary formulas that show a total of the hours of tasks set for for Last week, this week and next week.
For the current week, I've tried the following: =SUMIFS(WEEKNUMBER([Week Target]:[Week Target])@row = WEEKNUMBER(TODAY()), [Duration (minutes)]:[Duration (minutes)]) / 60)
What is wrong in this formula or is there a better way to do this?
Where do I add the -1 for last week's formula?
Help Article Resources
Check out the Formula Handbook template!