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:
http://www.mrexcel.com/forum/excel-q...tual-date.html
http://www.excelforum.com/excel-form...tual-date.html
http://www.vbaexpress.com/forum/show...to-Actual-Date
http://www.excelfox.com/forum/f2/get...ual-date-1992/