Need Summary Sheet formula to count age in weeks of assignment
I have a column which is the Assigned Date of a task.
I use this formula in the summary sheet to count how many items are a week old from todays date: =COUNTIF([Assigned Date]:[Assigned Date],
What would the formulas be to count assignments that are 2 weeks old, 3 weeks old, 4 weeks old, etc.
Help Article Resources
Check out the Formula Handbook template!