Forum Discussion
Subtract if true
I have a sheet with Covid vaccine bookings. It is for checking 2nd dose is more than or equal to 21 days from 1st dose I have it showing the number of days from Dose 1 to Dose 2 Also have a TRUE o...
can the list be modified in a more efficient format like this?
it basically subtracts the number of hours from midnight dose day1,
then calculates the number of days from dose day1, then adds the hours from midnight to proposed dose day 2 and
only 1 name (so no double booking mistakes).
- Not really. The 2nd dose only people do not need a booking. The only two things of interest is:
1- the number of days between people with a 1st and 2nd Dose
2- Anyone with a 1st dose and no 2nd Dose booked.
All the data comes out of a booking or appointment database with a date range set for several weeks in the future. It is thousands + of bookings which is why I would like to test it automatically
