Auto increment date in formula based on another cell

GARTHMAN

New Member
Joined
Apr 3, 2013
Messages
1
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:

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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

Watch MrExcel Video

Forum statistics

Threads
1,122,370
Messages
5,595,768
Members
414,017
Latest member
surajks

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