I want to know number of sales happend in each calender week. So when user select a week they could able to see number of sales happened on that particular week.
To allow the user to select a week, i dont have any week field. So i think i neeed to create a master calender.
But,Since the table has StartDate and EndDate, I am not sure how can i link these 2 dates to create a calender?
I have gone through the intervalmatch function and tried to apply it for my requirement. But i am stuck while writing the script for my requirement. May be because i never used this before.
My requirement is to count the candidates occupied the room PER WEEK.
For each PersonID, i have From and ToDate. But dont have another single date which i can use in intervalmatch.
How can i use intervalmatch in this scenario?
Please have a look at the attached app i developed for my requirement.
If you look at ERoom Sheet, the Date range(FromDate and ToDate in the ERoom Sheet) is more than a week. In some row, the week range can be 3 weeks and different in other row.
So, how can I add one Week Number for each row, in the sheet?
