excel corresponding a formula with a date

[Date Corresponding With Formula]

I have multiple formulas running down my page in column b to rip certain
things from my sales reports that i have saved in my documents. When i save
these sales reports they get saved with a certain date of the week ending.I
need a formula that will be able to correspond with the dates going down the
page in column a, as i dont want to go down through hundreds of formulas to
manually change the date. there must be a certain formula that can be
included in my formula to rip this certain information.

06/12/09 ='Macintosh
HD:Users:Lianeocuments:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11
13/12/09 ='Macintosh
HD:Users:Lianeocuments:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11
20/12/09 ='Macintosh
HD:Users:Lianeocuments:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11

so as you can see i pull this certain formula down in b1 down to b3 it pulls
down the same date being 061209, i need to be able to pull this down and for
the certain formula to match the date that is in a1 to a3? otherwise i will
have to go down the page in every formula and change the date so it will pull
the correct information from the correct sales report that is saved in my
documents.

can someone please help me work out a formula that will correspond with what
im doing?

thank you for any help

 

[Stefi]

Try this:
=REPLACE("'Macintosh
HD:Users:Lianeocuments:[DeeWhySalesreport061209.xls]Sales
Sheet'!$I$11",C1-7,6,TEXT(A1,"ddmmyy"))

--
Regards!
Stefi



„Date Corresponding With Formula†ezt írta: