Hi
Just want to know if the following is possible.
On my file on sheet 3 I have 3 different dates that I put in, two from sheet 1 and sheet 2.
The 3rd date in column F is “Return date.
I need this date to be one day before column D “Date Back”, but if the date is on a Saturday, Sunday or Monday, it must come back the Friday before,
and if I can also put holidays dates in so that It come before the holiday day.
Here is a sample of my file.
Thank You
Bookmarks