Complicated excel formula needed in date format

[nitaisorganized]

Please help with me with calculating the formula for the due date column:

I need to calculate the due date for 3 different types reports with varying timelines and dependencies. Each due dates must fall on business days but is calculated based on calendar days from pre-defined start dates (if due date falls on a weekend, the formula must auto- select for the previous Friday).
The three types of reports (A, Q, E) will be entered under column "Type of Report"
the two types of start dates (RPED, DOA) will be entered in two different columns "RPED" "DOA".
Report A is due 45 calendar days from its RPED
Report Q is due 15 calendar days from its RPED
Report E is due 11 calendar days from its DOA

eg. [TABLE="align: center"]
<tbody>[TR]
[TD]Type of report[/TD]
[TD]RPED[/TD]
[TD]DOA[/TD]
[TD]Due Date [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]08/03/2015[/TD]
[TD]12/03/2014[/TD]
[TD]09/17/2015[/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD]10/09/2015[/TD]
[TD]10/01/2015[/TD]
[TD]10/23/2015[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]n/a[/TD]
[TD]10/09/2015[/TD]
[TD]10/20/2015[/TD]
[/TR]
</tbody>[/TABLE]

Many thanks!

 

[JoeMo]

I think your due date for the Q report is off by one day.

Copy the formula in D2 down.

Excel Workbook
	A	B	C	D
1	Type of report	RPED	DOA	Due Date
2	A	8/3/2015	12/3/2014	9/17/2015
3	Q	10/9/2015	10/1/2015	10/24/2015
4	E	n/a	10/9/2015	10/20/2015
Sheet10

 

[nitaisorganized]

I think your due date for the Q report is off by one day.-

Copy the formula in D2 down.
Sheet10

*	A	B	C	D
Type of report	RPED	DOA	Due Date
A
Q
E	n/a

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:96px;"><col style="width:68px;"><col style="width:68px;"><col style="width:75px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]8/3/2015[/TD]
[TD="align: right"]12/3/2014[/TD]
[TD="align: right"]9/17/2015[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]10/9/2015[/TD]
[TD="align: right"]10/1/2015[/TD]
[TD="align: right"]10/24/2015[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]10/9/2015[/TD]
[TD="align: right"]10/20/2015[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula D2 =IF(A2="A",B2+45,IF(A2="Q",B2+15,C2+11)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Dear Joe, Thank you for the response. I believe that the due date is correct on my sheet because the due date fell on a weekend, it was corrected to the friday before. (All saturday and sunday due dates will need to be autocorrected to Friday). Please re-advise.

 

[nitaisorganized]

If due date falls on Sat or Sun, the formula should correct to Friday. Please let me know.

 

[JoeMo]

If due date falls on Sat or Sun, the formula should correct to Friday. Please let me know.

Sorry, I read your request too quickly and missed the weekend shift to Friday part.
Try this:

Excel Workbook
	A	B	C	D
1	Type of report	RPED	DOA	Due Date
2	A	8/3/2015	12/3/2014	9/17/2015
3	Q	10/9/2015	10/1/2015	10/23/2015
4	E	n/a	10/9/2015	10/20/2015
Sheet6