Hi, I know access would be a better option but i need to try and do this in excel. I'm trying to create a very basic booking sheet which will work out capacity for my kennels on each night. My columns will be Surname, Pets Name, Arrival Date and Departure Date. On another sheet I will have all my columns dated 1st, 2nd 3rd etc to create the days in a month.
Is there anyway excel will calculate nightly capacity from the two dates on each line i.e. Arrival and departure date and enter it into my calendar?
My knowledge of excel is fairly basic so apologies if I've asked any daft questions!

Many thanks