Thank you for a quick response and solid answer. There isone missing element though is I want to include all dates within the activemonth as 1 also. So far your example the +30 as well as all dates in September.This allows the team members some time to close out there projects as completefor the month as I also have a filter set for all projects in-progress.





=([@Date]>=TODAY())*([@Date]<TODAY()+30)





To achieve what I wanted required me to do a 3 step processthe range dates:

• Column X
  1. =IF(MONTH(J2)=MONTH(TODAY()),1,0)
• Column Z
  1. =COUNTIF(J2,"<"&TODAY()+30)
• Column AA
  1. =IF(OR(X2=1,Z2=1),1, 0)

Any thoughts on how that could be combined as a single formula/singlecolumn