Conditional Statement using data columns

p45cal · #1 03-21-2022, 07:58 AM

Shame the op NLJ can't be arsed to say thank you, a shorter version in 365 might be:

Code:

=LET(HdrDte,Table13[[#Headers],[Q2 2022]],dt,DATE(RIGHT(HdrDte,4),MID(HdrDte,2,1)*3+1,0),IF((MIN(Table13[@[End]:[End]],dt)-MAX(Table13[@[Start]:[Start]],EDATE(dt,-3)))>0,"x",""))

Marcia · #2 03-21-2022, 03:06 PM

Thank you. I need a free weekend to understand the code and a further reading on the LET function is called for.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting using specified range instead of With Selection statement	slouw	Excel Programming	3	01-26-2019 06:24 AM
If Statement for Outlook VBA: Time & User defined columns	Son	Outlook	0	10-02-2015 11:02 AM
Conditional Formatting/If Statement with Dates	AndrewEnos	Excel	2	07-22-2014 07:34 AM
Conditional Formatting for columns	MattMurdock	Excel	1	08-09-2012 10:03 PM
Conditional Formatting to Hide Rows or Columns?	sczegus	Excel	0	09-26-2006 04:17 PM