calculating the number of people per day between two dates

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
Hello, I'm creating a quickbase to manage the logistics of an international conference.

I would like to be able to work out which days each person is in country, so I can track the number of attendees each day (on Monday we have 147, Thursday we have 92 etc..). Is there anyway of being able to name the days between two flights: 

Land on the 19th November (Sunday), depart on the 25th November (Saturday), as such this person will be in country Sun, Mon, Tues, Wed, Thurs, Fri, Sat

And then being able to sum all mon? sum all tues? etc..
Photo of Liam Bloundele

Liam Bloundele

  • 70 Points

Posted 2 years ago

  • 0
  • 1
No problem

Make a formula numeric field called [Monday Count] and make a formula which calculates to either a 1 or a 0 based on if they attended on Monday. Post back if you need help with that.

Then duplicate that field and adjust the formula for a Tuesday. And then again for each day.

Then simply run a List All type report with these fields and you will have your totals at the bottom of the report.