Greetings,
Maybe I missed the answer but need help in applying a formula to only count dates that are within the last year. My data is pulled from SharePoint Lists then using another tab I am able to count how many items are done based on each section (currently have 5 different sections)
The formula I am using is:
COUNTIFS(Table1[Section],”Section”,Table1[Safety],”<>”)
I would like it to only count the dates in Safety that are within the last year when the sheet is refreshed.
Any help will be greatly appreciated.
Bookmarks