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(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))
Best Answer
-
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))
Answers
-
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))
-
Works beautifully, thank you.
I will spend some time learning the proper syntax for future use.
🙏
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!
