If date is Current Month 1 or within 30 days
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?
|