Referencing a worksheet in an Excel 2010 formula

[rdvorak17]

I am using Excel 2010. Let's say I have a workbook that contains 13 worksheets. The first worksheet is named "Summary" and the remaining 12 are the months of the year (January-December). In "Summary" I want to ask the user to choose a month. Then, I use '=DATE(YEAR(E1),MONTH(E1)+1,1)' to increment to the following month. That's done a total of 2 times so the user enters 06/01/2016 and they get June, July, and August. Now, I want to take figures from each of the 3 named months and sum them on the "Summary" worksheet. The problem I am running into has to do with using the INDIRECT() formula and the fact that the Months cells aren't formatted as Text but as Date (actually Custom Dates). How would I go about referencing the June, July, and August worksheets in a formula if the data in the cells isn't Text? Something like =B1!H3 if I'm trying to access =July!H3. Hopefully this makes sense. If not, let me know and I can try to clear it up. Thanks!

 

[AlphaFrog]

Try something like this...

INDIRECT(TEXT(DATE(YEAR(E1),MONTH(E1)+1,1),"mmmm")&"!H3")

 

[Jonmo1]

Or, since you ALREADY have those dates in cells, say A1 for example

INDIRECT(TEXT(A1,"mmmm")&"!H3")

 

[rdvorak17]

Or, since you ALREADY have those dates in cells, say A1 for example

INDIRECT(TEXT(A1,"mmmm")&"!H3")

This is exactly what I was looking for. Thanks so much!

 

[Jonmo1]

You're welcome.