3 Replies Latest reply on Apr 12, 2016 5:16 PM by swaroop.gantela

    Need help with School Calendar that have start/end dates

    Jamil Patiag

      I was trying to create a view to see when schools are on break, but am having a difficult time.  I came across this discussion: Re: Table structure with open date and close date columns , and wanted to mimic the view, but am unable to.


      Basically, I have start and end dates for multiple cities and want to see how many are on break during specific dates.  I have attached a workbook as an example.


      Sheet 1 is from the example on the post listed above.  I want to mimic this.

      Sheet 2 is my sample data that I need help with.