Tuesday, November 21, 2017

yogi_Compute Number Of Days Parked From In Out Data For Parking

Google Spreadsheet   Post  #2295

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-21-2017
question by: UliTol
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/nrxsBbg3BTU;context-place=forum/docs
Need help counting dates between dates
Hey,  I am a bit puzzled,  can I get some help with a formula to help count between dates.

The parking data tab shows a patron entry,   it shows the time in and time out

Say person A parked form 09/28/17 to 10/03/17
and person B parked from  10/02/17  to 10/04/17
I need to track how many people parked per day.
so it would look something like this

10/1 - 1
10/2 - 2
10/3 - 2
10/4 - 1

and so on.


https://docs.google.com/spreadsheets/d/1j9-n4VTMzGgJDN0COqRvdL-L19LCtNLk_IDbqmEt1SY/edit?usp=sharing
Thank you!


No comments:

Post a Comment