Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter

p45cal · #2 12-04-2019, 06:06 PM

This formula will highlight cells containing a date within 45 days of end of today()'s quarter:

Code:

=AND($H6<=EOMONTH(TODAY(),MOD(3-MONTH(TODAY()),3)),$H6>EOMONTH(TODAY(),MOD(3-MONTH(TODAY()),3))-45)

and this one will highlight the same as above plus any date prior to the start of today()'s quarter:

Code:

=OR(AND($H6<=EOMONTH(TODAY(),MOD(3-MONTH(TODAY()),3)),$H6>EOMONTH(TODAY(),MOD(3-MONTH(TODAY()),3))-45),$H6<DATE(YEAR(TODAY()),FLOOR(MONTH(TODAY())-1,3)+1,1))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditionally Highlighting Blank Cells by Quarter in Current Calendar Year	PrincessApril	Excel	2	11-29-2019 03:31 AM
Microsoft word Page has 4 quarter squares on each paper	AZn	Word	3	05-18-2017 07:50 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Group Date by Quarter in PIVOT TABLE	shilabrow	Excel	6	04-24-2014 10:44 AM
Conditional Mail Merge per Student and Quarter	marysilvaramos	Mail Merge	1	01-29-2013 07:17 PM