Hi I am currently helping a friend out with a reservation spreadsheet. The issue I have is certain dates fall into different price brackets.
For example B2 Start date (01/05/15) C2 End Date (14/05/15) however the dates cross two price bands 5 days in low season and the remaining in high season is there a formula that can count from a list how many dates fall in low and how many in high? I have a list on one worksheet that details every date and which is Low or High can someone help please
Cheers
For example B2 Start date (01/05/15) C2 End Date (14/05/15) however the dates cross two price bands 5 days in low season and the remaining in high season is there a formula that can count from a list how many dates fall in low and how many in high? I have a list on one worksheet that details every date and which is Low or High can someone help please
Cheers