Formula if date is within range

[nymets5485]

Hi Everyone,

I am not sure if there is a solution for this but i am just going to throw it out there. I have 4 workbooks that are used to track statistics and individual offices. I am trying to make a separate workbook to display important data points from the other 4 (see screen shots)

sample of summary workbood

Sample of site workbook

What i am looking for is a formula to enter in the "Monthly Average" box that will just pull the the value in box E34 automatically based on if the current date falls within that month. I am sure the separate monthly tabs might make this impossible but throwing it out there. Thanks!!

 

[levipe]

It's not an elegant looking formula but something like this should work:

=CHOOSE(MONTH(TODAY()),'Jan 23'!E34,'Feb 23'!E34,….,'Dec 23'!E34)

If you're going to have more than a couple of these, it's easier on your worksheet to put the =TODAY() is another cell (or defined name) and then reference that.

 

[nymets5485]

This worked! Thank you so much!