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"

1760

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-questions/838050-get-date-prior-actual-date.html
http://www.excelforum.com/excel-formulas-and-functions/1068444-get-date-prior-to-actual-date.html
http://www.vbaexpress.com/forum/showthread.php?51858-Date-Prior-to-Actual-Date
http://www.excelfox.com/forum/f2/get-date-prior-to-actual-date-1992/

[HaHoBe]

posted as well in
Get Date prior to actual Date (http://www.excelforum.com/excel-formulas-and-functions/1068444-get-date-prior-to-actual-date.html)
Get Date prior to Actual Date (http://www.mrexcel.com/forum/excel-questions/838050-get-date-prior-actual-date.html)
Date Prior to Actual Date (http://www.vbaexpress.com/forum/showthread.php?51858-Date-Prior-to-Actual-Date)

Ciao,
Holger

[Excel Fox]

Here's how you can get date prior to a date

=INDEX($B$4:$B$19,MATCH(B5-1/9^9,$B$4:$B$19,1))

[Excel Fox]

And the solution to your Excel file

Use K5=F5+INDEX($H$4:$H$19,MATCH(B5-1/10^9,$B$4:$B$19,1))+INDEX($J$4:$J$19,MATCH(B5-1/10^9,$B$4:$B$19,1)) and drag down

[mackypogi]

Hi Excel Fox,

Thank you for your response, I will try and get back to you

[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"

1760

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 (http://www.mrexcel.com/forum/excel-questions/838050-get-date-prior-actual-date.html)
Get Date prior to actual Date (http://www.excelforum.com/excel-formulas-and-functions/1068444-get-date-prior-to-actual-date.html)
Date Prior to Actual Date (http://www.vbaexpress.com/forum/showthread.php?51858-Date-Prior-to-Actual-Date)
http://www.excelfox.com/forum/f2/get-date-prior-to-actual-date-1992/

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