Formula - Date Between

Ozu

Hello All,

I need to pull data from the sheet for the last 10 days, but the formula I used isn’t returning the correct results. Could someone review the formula and help identify what might be wrong?

Matt Lynn#

@Ozu On the surface it seems your < and > are backwards. Looks like it's trying to count things that are greater than or equal to today+10 and less than or equal to today. I think if you switch those arrows it would be ok.

If you still have an issue sometimes when pulling from date sources you need to wrap the date in a iferror to allow for blanks in the source data.