Auto increment date in formula based on another cell

GARTHMAN

New Member
Joined
Apr 3, 2013
Messages
11
I have a workbook with a separate tab for each date a deposit is made. The following formula is used to pull info from "Daily Master.xmls":

='[APR 02, 2013.xlsm]Deposit Recon'!$E$6

I have about 50 formulas similar to this on every tab.

Is there a way to automatically change the formula on the successive tabs so that it will increment the formulas as follows

='[APR 03, 2013.xlsm]Deposit Recon'!$E$6
='[APR 04, 2013.xlsm]Deposit Recon'!$E$6
='[APR 05, 2013.xlsm]Deposit Recon'!$E$6
='[APR 06, 2013.xlsm]Deposit Recon'!$E$6 etc.

I would prefer to do this without VBA if anyone knows how to do that, but will use vba if it is the only option (for some reason VBA is frowned upon in this establishment and I will get my knucles rapped).Thanks for any insights you can provide.





 
Last edited:

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
You can use INDIRECT for this.

But exactly HOW should we incriment the date?
Will you put the required date in a cell? Which Cell?
Should it just use Today's date in some way?
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Just to get things rolling

Let's assume that cell A1 contains the date April 03, 2013

You can use this to incriment it by one as the formula is pulled down.
=INDIRECT("'[" &TEXT($A$1+ROWS(A$1:A1)-1,"mmm dd, yyyy")&".xlsm]Deposit Recon'!$E$6")
 
Solution
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,139
Messages
5,835,633
Members
430,372
Latest member
contentment

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top