Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel corresponding a formula with a date
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:Liane:Documents:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11 13/12/09 ='Macintosh HD:Users:Liane:Documents:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11 20/12/09 ='Macintosh HD:Users:Liane:Documents:[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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel corresponding a formula with a date
Try this:
=REPLACE("'Macintosh HD:Users:Liane:Documents:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11",C1-7,6,TEXT(A1,"ddmmyy")) -- Regards! Stefi €˛Date Corresponding With Formula€¯ ezt Ć*rta: 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:Liane:Documents:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11 13/12/09 ='Macintosh HD:Users:Liane:Documents:[DeeWhySalesreport061209.xls]Sales Sheet'!$I$11 20/12/09 ='Macintosh HD:Users:Liane:Documents:[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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
I want to add 6 months to a certain date in a formula (Excel) | Excel Worksheet Functions | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Excel date formula | Excel Discussion (Misc queries) | |||
Excel formula with date constraints | Excel Discussion (Misc queries) |