Counting Dates within a range
I am trying to get a count of the number of rows with dates that meet one or another condition. I know I cant use Countif so I planned on adding a column next to my date column to capture the data.
One condition is that the date is either within the next 30 days OR the date is in the past.
Here is what I have so far and it returns #UNPARSEABLE ( I see that error so much, I am planning on naming my next dog 'UNPARSEABLE)
=IF(OR[Survey Next Due Date]1 <= Today(+30), [Survey Next Due Date]1 < TODAY(0)), "1"))