Lookup Date Value based on 3 Values

I have data that contains all the days in a year G7:I372. I want to lookup a value based on month, date and return the result. The sheet I am using contains a list in A3. As I change the value of A3, i want the dates to update. See attached sheet.

You're going a long way for something as simple "create a listing of all valid dates in a month". You don't really need that chart in G H and I. All you need is a simple conversion chart (I added it in columns L M) to reference your "text" months as numbers.

In the attached, both columns A and B operate off of the reference in A3 only and the small chart. The months will end where they need to, even on leap years. Be careful with the dates 29,30 and 31, those formulas are slightly different.

You can do away with all that extra stuff..unless it serves some purpose you've not explained.

In truth, you don't really need the A column either...

JB, you could extend further and dispense with lookup table altogether using DATEVALUE, eg:

B8: =DATEVALUE("1"&$A$3)

That's a great trick! Nice.

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]