View Single Post
 
Old 03-21-2022, 07:58 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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",""))
Reply With Quote