Formula error on Duplicate date check

Formula error on Duplicate date check

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([email protected]; “”); IF(ISBLANK([email protected]; “”; IF(COUNTIFS(Slutdato:Slutdato; <[email protected]; Slutdato:Slutdato; >[email protected]) + COUNTIFS(Startdato:Startdato; >[email protected]; Startdato:Startdato; <[email protected]) + COUNTIFS(Startdato:Startdato; <[email protected]; Slutdato:Slutdato; >[email protected]) - 3) > 0; 1; 0))


Best Answer

Answers

  • Works beautifully, thank you.

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

    🙏

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

Sign In or Register to comment.