View Single Post
Old 09-29-2019, 09:53 AM
Sje Sje is offline Windows 10 Office 2016
Join Date: Sep 2019
Posts: 2
Sje is on a distinguished road
Default 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?
Reply With Quote