If date is Current Month 1 or within 30 days

		Microsoft Office Forums > Microsoft Excel > Excel
If date is Current Month 1 or within 30 days

09-30-2019, 10:40 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 932

Code:

=([@Date]>=TODAY())*OR([@Date]<TODAY()+30,MONTH([@Date])=MONTH(TODAY()))

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 AM.