I can get the number of completed tasks last week (7 days) using
=COUNTIFS(Status:Status, "Complete", Finish:Finish, @cell > TODAY(-7))
How do I get the number of tasks completed, say... between 7-14 days in the past?
thank you,
@Allen4480
You can do it 1 of 2 ways, you can use an AND formula or just have 2 day formulas.
=COUNTIFS(Status:Status, "Complete", Finish:Finish, @cell > TODAY(-14), Finish:Finish, @cell < TODAY(-7))
OR
=COUNTIFS(Status:Status, "Complete", Finish:Finish, AND(@cell > TODAY(-14), @cell < TODAY(-7))
Nailed it!
Thanks, Eric. Much appreciated
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
