I need to be able to create a rolling 30 day chart. I have looked at some of
the postings online and found them to be very helpful.
I need to make a slight modification to do look at days rather than months.
I am utilizing NAMES. here is my chtCar
code:=IF(Sheet1!$A$2:$A$75=(TODAY()),OFFSET(Sheet1 !$A$1,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtlen,COUNTA(Sheet1!$A:$A)-1),1))
I think I am close however I get FALSE in my results.

I need help! any suggestions?