I have an "if" statement to enter number 1 in column B if the date is in the current month. Works great, but limiting. I still want to count dates within the current month but also count if it is within 30 days out of todays date. So current month and +30 days out make it a 1 in column A.
I am trying to esitmate capacity for the team by identifying projects that will close within 30 days by the date entered in column A. Thoughts?

When Date is within 30 days, In30=1, otherwise 0

Attached Files

DatePeriod.xlsx (10.0 KB, 9 views)

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

Like