Hi all,

I'm using Excel 2010 and I have a table with arrival date and departure dates for individuals. I need to fill the corresponding columns relating to months with the number of nights spent. Say, if someone arrived on 26.02.13 and left on 05.03.13, 3 nights would go in the February Column and the remaining 4 nights would go into the March Column.
I can't find the right formula to do this.

Can a pivot table help me here?

I am enclosing the table for a clearer picture of the problem. sample.xlsx