Need formula help for COUNTIFS and certain dates

Question

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 · Accepted Answer

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