I'm trying to solve the following for a basic room cleaning task daily report.
Each Room has a reservation Start and End Date.
Based on Company policy a room is cleaned on day +4 after start date and then Every 8 days after that first clean.
What I cant get to grips with is how to calculate to indicate if the room requires a clean based on todays date, taking into account start date and the frequency of the clean program.
Thanks in Advance.
If Start date in Column B and and End date in Column C please try for overview Cleaning dates in D2 and copy down:Formula:
Please Login or Register to view this content.
Last edited by HansDouwe; 12-08-2022 at 01:43 AM.
And try for rooms to be cleaned today:Formula:Please Login or Register to view this content.
Thankyou this helped immensely.Originally Posted by HansDouwe
And try for rooms to be cleaned today:Formula:Please Login or Register to view this content.
You are welcome, thanks for the feedback and I,m glad to have helped.
Please considder adding reputation to the answers of any helpers if you think they deserve it.
Edit: Thanks for the rep,
Last edited by HansDouwe; 12-09-2022 at 04:23 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks