|
|
#7
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","")) 
|
|
|
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 |
Windows 10 
Office 2019
Threaded Mode