Hello World!
I have seen similar post but i was finding it hard to understand. I saw some forums taking about creating a calender but I have no idea on how to do that.
My query is that I have a table called Assessments and I would to calculate the number of days the assesment was open for, excluding weekend. There are blanks in the end date becase the are some assessments which are still open however I want to calculate how long the assessment are opened to day for these fields.
Here is the data.
| ID | AssessmentType | Start Date | End Date | No of Days |
| 194105 | Assessment | 19/09/2017 | 30/10/2017 | |
| 203415 | Assessment | 18/09/2017 | 09/02/2018 | |
| 206458 | Assessment | 09/02/2020 | 22/02/2020 | |
| 206461 | Assessment | 09/02/2018 | 22/02/2018 | |
| 208758 | Assessment | 17/11/2018 | 22/08/2020 | |
| 211205 | Assessment | 21/10/2020 | | |
| 212010 | Assessment | 20/03/2019 | 07/05/2019 | |
| 213061 | Assessment | 28/06/2017 | 24/07/2017 | |
| 215616 | Assessment | 09/10/2017 | | |
I hope this was clear to everyone 🙂
Thanks
Viral
