If date is Current Month 1 or within 30 days

Sje · #3 09-30-2019, 11:21 AM

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

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