Multiple If Statements

[joeldsmt]

Hello,

I have a workbook with three sheets in it. I want Sheet 3 to give me details from Sheet 1.

Sheet 1 is basically a list of items to do on Column A. Cell B2 through Cell M2 are 12 months, and below each month we are entering the date the last item in Column A was worked on.

I want D2 in Sheet 3 to tell me the value in the most current data in the cells from Sheet 1.

For instance i want to see that D2 says the date that item was last worked on for the month of January and if there is an entry in the month of Feb. It will disregard January and enter the February details and so forth for the next months.

I will do this on subsequent rows but I need help figuring out the first row.

Any suggestions would be greatly appreciated.

Thank you in advance,
JM

[oldchippy]

If you have a list of dates, use the MAX function to find the last one.

[joeldsmt]

MANY MANY Thanks. It worked beautifully!!!

[oldchippy]

Glad to help - thanks for the feedback