Countifs with an IF statement and dates

Hi, I have two dates in my sheet - a final filing date and an extended final filing date - I am trying to identify the number of advertisements that are closed (for clean ads)- I can count with this countifs statement the FFD but don't know how to factor in the extended final filing date when that field contains a date (is., is not blank).

=COUNTIFS([CLEAN POSITION]:[CLEAN POSITION], 1, [FINAL FILING DATE]:[FINAL FILING DATE], <TODAY(-1), [APPLICANT/CANDIDATE NAME]:[APPLICANT/CANDIDATE NAME], "ADVERTISEMENT")

Any help would be greatly appreciated!

Thank you all!

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @DHR Temp Assignment Team

Hope you are fine, Could you please share a screen shot of your sheet after removing any sensitive data.

DHR Temp Assignment Team

sorry, I am unable to upload a picture for some reason with this tool - here's the columns

Final Filing Date Extended Final Filing Date Clean (check box)

2/26/21 3/5/21 Checked

Looking to count the rows that have Clean checked and a blank EXT FFD would count only the FFD; if there is a EXT FFD it would count the EXT FFD

DHR Temp Assignment Team

sorry, I am unable to upload a picture for some reason with this tool - here's the columns

Final Filing Date Extended Final Filing Date Clean (check box)

2/26/21 3/5/21 Checked

Looking to count the rows that have Clean checked and a blank EXT FFD would count only the FFD; if there is a EXT FFD it would count the EXT FFD

Bassam Khalil

@DHR Temp Assignment Team

Please send to my Email

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

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.