Overlapping Dates and Auto-Flagging

aeparkerson

Hello,

I have created a communications plan for my organization. I would am trying to auto-flag (in the Overlap row) any communication entry that has overlapping Start/End Dates of the same Delivery Method. I am using the formula below, but receive the #unparseable error. What am I doing wrong?

=IF(COUNTIFS(Delivery Method:Delivery Method, @cell = Delivery Method@row, [Start Date]:[Start Date], @cell <= [End Date]@row, [End Date]:[End Date], @cell >= [Start Date]@row) > 1, 1)

Michael Culley

You need brackets around [Delivery Method]:[Delivery Method]

aeparkerson

Hi Michael, I am still getting the unparseable error.

Michael Culley

@aeparkerson

Here also:

@cell = [Delivery Method]@row

Michael Culley

Should look like this:

=IF(COUNTIFS([Delivery Method]:[Delivery Method], @cell = [Delivery Method]@row, [Start Date]:[Start Date], @cell <= [End Date]@row, [End Date]:[End Date], @cell >= [Start Date]@row) > 1, 1)