Counting Occurrences During Date Range

I have a roster of temporary workers that come in on different days and leave on different days. I need to calculate expected hotel nights by counting the number of workers who will be in the city on each day. I'm at a loss on how to do that. I really just need to know how many hotel nights to expect to need each month (1 room/person/night).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!