Hello,
I have a list of arrival and departure dates for all the guests staying at a property
I would like to show in one column all of the days that are every 3rd day from the arrival, and a second list for every 7th day from the arrival. All the way until the the departure day
The first column I’d be able to sort by todays date to find out which rooms need regular cleaning today, the second for linen changes.
For example if a reservation was
Cell A1:06/01/2022 Cell B1: 06/14/2022 then
Cell C1: =A1+3= 06/04/2022
Cell D1 =B1+7= 06/08/2022
Then if today was was June 8th, I would sort the column to show June 8th to see a list of the reservations due for linen change today.
However, most reservations are 6 months+ in length and I cant do a new column for every increment of 3 & 7. It's too much work.
Dorm Room Check-In Date Expected Departure Date Shift
A 5 5/25/2022 6/20/2022 Day
C 15 6/2/2022 12/24/2022 Nights
C 14 6/1/2022 12/31/2022 Day
Thank you!
Bookmarks