Need formula help for COUNTIFS and certain dates
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,
Help Article Resources
Check out the Formula Handbook template!