Get Date prior to Actual Date

[mackypogi]

Hi

I would like to re create my previous post,
I thought I can sort things out by just getting the formula for the Date prior to actual date, but now I really need help.
Ok, so here is my situation,
I need to get the Date Prior to Actual Date but it has multiple criteria.
I need a formula that is flexible so that I will just drag it down and it will calculate correctly.
I will attach the sample file I have so far, I also used the formula given by "Bebo"

sample.xlsx

I hope you guys out there could help me out. Thank you so much.

I also posted this question in below link: crosspost:
Get Date prior to Actual Date
Get Date prior to actual Date
Date Prior to Actual Date
http://www.excelfox.com/forum/f2/get...ual-date-1992/

Guys, I updated my post, and hopefully you can help me out.