Get Date prior to Actual Date

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"

Attachment 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-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/

posted as well in
Get Date prior to actual Date
Get Date prior to Actual Date
Date Prior to Actual Date

Ciao,
Holger

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))

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

Hi Excel Fox,

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

Quote:

---

Originally Posted by 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"

Attachment 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
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.