Travel Shared Expense Calculator

Hello everyone. I just stumbled across this forum as I searched for some help for a formula.

I'm going on a trip with a group of 13 people. We have rented a vacation home in the mountains for 4 nights. Some people will be there for all 4 nights but others are coming for 3 nights and some for only 2 nights. I want to create a spreadsheet in Excel that will split the entire cost of the trip which is $3000 per person according to the number of nights they stayed. Those that stayed for less than 4 nights should be charged accordingly.

Any help is appreciated.

Thanks guys. I actually figured it out after I posted the question but I can also use the spreadsheet you linked. Thank you.