Good day,
Let's say each student at a school is assigned a student ID (Student #) and they can choose to eat either pizza or a hamburger each day. They submit a form requesting what they want for lunch or if they want to switch from one item to the other. I need two formulas, and I'm drawing a mental blank - I want to find out the amount of days between the "start date" and the "form received" date expressed as days (i.e. 27 days) and I also want to find out how often students are switching from pizza to hamburgers. Any help would be greatly appreciated...
Let's say each student at a school is assigned a student ID (Student #) and they can choose to eat either pizza or a hamburger each day. They submit a form requesting what they want for lunch or if they want to switch from one item to the other. I need two formulas, and I'm drawing a mental blank - I want to find out the amount of days between the "start date" and the "form received" date expressed as days (i.e. 27 days) and I also want to find out how often students are switching from pizza to hamburgers. Any help would be greatly appreciated...
Student # | Start Date | End Date | Form Received | Lunch Choice |
1 | 08/13/2012 | 12/31/9999 | 05/29/2013 | Pizza |
2 | 10/22/2019 | 01/19/2020 | 10/29/2019 | Hamburger |
3 | 04/02/2017 | 12/31/9999 | 04/07/2017 | Hamburger |
4 | 04/12/2020 | 12/31/9999 | 09/29/2020 | Pizza |
5 | 04/08/2020 | 07/29/2020 | 04/17/2020 | Hamburger |
5 | 07/30/2020 | 12/31/9999 | 08/07/2020 | Pizza |
6 | 02/20/2012 | 12/31/9999 | 05/22/2012 | Pizza |
7 | 04/01/2013 | 03/26/2014 | 05/09/2013 | Pizza |
7 | 03/27/2014 | 03/31/2015 | 04/03/2014 | Hamburger |
7 | 04/01/2015 | 12/31/9999 | 05/13/2015 | Pizza |
8 | 04/01/2016 | 07/24/2019 | 05/04/2016 | Pizza |