[ExcelDates] Calculate no of days on a monthly basis

[Theuser]

Hello,

I have a worksheet, where basically i want to find out the 'Room Nights' from Arrival & Departure Date, But the no of days between the two dates is to be bifurcated into months.

Eg. Arrival Dt: 01-02-2014
Departure Dt: 02-02-2014
Room Nights: 1 night in Feb

Arrival Dt: 25-07-2014
Departure Dt: 02-08-2014
Room Nights: 7 nights in July & 1 night in Aug


However, if,
Arrival Dt: 31-01-2014
Departure Dt: 01-02-2014
Room Nights: 0 night in Feb(only, 1 night in Jan)
This is because the data is required only for the period Feb to Nov
Similarly,
Arrival Dt: 30-11-2014
Departure Dt: 01-12-2014
Room Nights: 1 night in Nov(0 in Dec)

The Workbook attached should be able to give you more idea, of exactly what im trying to get.

Thanks,
Theuser

 

[Somendra Misra]

Hi,

Not really understood, but see the file.

Regards,