Work date out to show before a other date

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

Okay.. try using below formula:-

Formula:

Please Login or Register  to view this content.

where M1:M17 would contain your holiday list



Regards,
DILIPandey
<click on below * if this helps>

Put this function in F3, copy & paste it down

=D3-(IF(I3=7,2,IF(I3=1,3,1)))

you are welcome hendrikbez

cheers


Regards,
DILIPandey
<click on below * if this helps>