If date is Current Month 1 or within 30 days

Sje · #1 09-29-2019, 09:53 AM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate amount of days per month from a given timerange	Yde1203	Excel	3	05-02-2019 08:13 PM
Configure for 30 days, not calendar month	teapea21	Outlook	1	07-31-2014 09:05 AM
Formula to divide if no of days in month is 28	shilabrow	Excel	5	06-26-2014 12:17 AM
Date Field to add 10 Days to Current Date	Erbwon	Word	6	11-12-2012 06:17 PM
Auto insert current month's name and current year	Styler001	Word	4	01-25-2010 06:40 PM