Formula to calculate due dates and round down to nearest working day

[sph0ng]

Hi all,

Novice excel user here, I'm trying to calculate 2 things in a single cell:

1. due dates 3 months from start date which was pretty simple: =DATE(YEAR(B15),MONTH(B15)+3,DAY(B15))

2. and if the due date lands on weekends/holidays, to round down to nearest working date. If date is on a holiday in the middle of the week, then due date would be the working day before.

Sat/Sun => due date would be the Fri before

I can't seem to figure out #2 . I tried to add =workday function, but that always seems to break the formula. Any help would be appreciated.

 

[AhoyNC]

Try:

Excel Workbook
	A	B	C	D	E
1	Start Date	Due Date			Holidays
2	1/19/2019	4/18/2019			4/19/2019
3	2/15/2019	5/15/2019			5/27/2019
4	2/18/2019	5/17/2019
5	2/27/2019	5/24/2019
Sheet

 

[sph0ng]

Hey AhoyNC,

That's exactly what I was looking for, Thank You!

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.