Formula needed for dates that match or overlap
i.e
If the start date in column K is less than a end date in column M then return TRUE in column N, otherwise false
If the start date in column K is same as another start date, then return TRUE
Don't want to highlight any that leave and start on same date, only dates that are matching or overlap.
I need any dates that overlap to be highlighted.
i.e
If the start date in column K is less than a end date in column M then return TRUE in column N, otherwise false
If the start date in column K is same as another start date, then return TRUE
Don't want to highlight any that leave and start on same date, only dates that are matching or overlap.
I need any dates that overlap to be highlighted.