Hello everyone, I have column A where the dates are inconsistent due to weekends and holidays. I have a holidays tab where the holiday dates are stored. This formula is meant to pick the exact date from a year ago or the closest forward date.
E.g. if we have 30th of April 2024, we want the same date in 2023 however, that is a sunday so we should be picking 1st of May, Monday as that would be the date available in column A.
Bookmarks