Formula error on Duplicate date check

HOFF

Have found this formula in previous discussions but is unparseable.

I have gone through it a couple of times and think it is down to wrongly set parentheses, or?

Slutdato=enddate, Startdato=start date. Looking to flag (double booking) if startdates or enddates overlap.

=IF(ISBLANK(Startdato@row; “”); IF(ISBLANK(Slutdato@row; “”; IF(COUNTIFS(Slutdato:Slutdato; <=Slutdato@row; Slutdato:Slutdato; >=Startdato@row) + COUNTIFS(Startdato:Startdato; >=Startdato@row; Startdato:Startdato; <=Slutdato@row) + COUNTIFS(Startdato:Startdato; <=Startdato@row; Slutdato:Slutdato; >=Startdato@row) - 3) > 0; 1; 0))

Paul Newcome

Yes. There are some parenthesis issues with your formula. Below is a more simplified version.

=IF(OR(ISBLANK(Startdato@row); ISBLANK(Slutdato@row)); ""; IF(COUNTIFS(Slutdato:Slutdato; >= Startdato@row; Startdato:Startdato; <= Slutdato@row) >1; 1))

Paul Newcome

Yes. There are some parenthesis issues with your formula. Below is a more simplified version.

=IF(OR(ISBLANK(Startdato@row); ISBLANK(Slutdato@row)); ""; IF(COUNTIFS(Slutdato:Slutdato; >= Startdato@row; Startdato:Startdato; <= Slutdato@row) >1; 1))

HOFF

Works beautifully, thank you.

I will spend some time learning the proper syntax for future use.

🙏

Paul Newcome

Happy to help. 👍️