Need formula help for COUNTIFS and certain dates

SPRINGBOK

I am needing to count the instances in the TASHELL column that are greater than 1, but also whereby the date in the Request Submitted By column in greater than the date in the Static Date Column. I think I may be over thinking it by using the Static Date Column but I've looked at it for so long that I give up and am asking for help :)

I've tried this: =COUNTIFS(TASHELL:TASHELL, >=1, [Request Submitted date]:[Request Submitted date], > [static date]@row))) but doesn't work and I've tried: =COUNTIFS(TASHELL:TASHELL, >=1, [Request Submitted date]:[Request Submitted date], > "01/26/2022"))) but doesn't work.

Thanks so much,

Shelley

SPRINGBOK

Thank you so much...sorry for delayed reply...I actually figured out how to make a static date stay in a column by using the simple formula =DATE(2022, 1, 26)...this solved the problem with another work around...I've saved your response in my SS notes for further reference though!

Cheers,

Shelley

Jeff Reisman

@SPRINGBOK

Why the extra two parentheses at the end? Those may be your issue. Make sure the color-coding works, that the last end parentheses matches the first one after COUNTIFS.

=COUNTIFS(TASHELL:TASHELL, >=1, [Request Submitted date]:[Request Submitted date], > [static date]@row)))

SPRINGBOK

Thank you so much...sorry for delayed reply...I actually figured out how to make a static date stay in a column by using the simple formula =DATE(2022, 1, 26)...this solved the problem with another work around...I've saved your response in my SS notes for further reference though!

Cheers,

Shelley