Forum Discussion
davidmansour
Mar 04, 2025Copper Contributor
Count occurances of a number in range within after a certain date
Hello, I have a table with Dates in Column A and Drug levels in Column B. I wanted to count the number of drug levels below a certain value in Column B that are within the last 6 months. I cu...
HansVogelaar
Mar 04, 2025MVP
It should work. although I'd use EDATE(TODAY(), -6) instead of TODAY()-180.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar