Extract data from excel calendar

You might be able to use MATCH to find the date "row" in column A, then put that into INDEX, with some form of "count" for the column reference.

I suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

i uploaded a sample

i want to search the rows that have the calendar date in them and then pull the data in the cell directly below the date... so if i search 1/1/15 i want it to pull the number right below it....

godhan.bisht, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.