Hello! I have attached a dataset where I am trying to create a formula to derive the closest check-in date to the clean date for the same property.
For the same property, there are different clean dates for one check in date. I would like to simplify the data set to show the check in date closest to the clean date.
Thank you!
Bookmarks