Try this...

Assuming the dates are for the year 2010.

=LOOKUP(DATE(2010,P32+1,0),A1:AJ1)

Format as Date

--
Biff
Microsoft Excel MVP


"Jeff Jensen" wrote in message
...
Range A1:JA1 has all our work days for the year (holidays and weekends are
excluded).

In P32 I want to enter the number of a month (i.e. 1 = Jan, 2 = Feb, etc.)
and have a formula in Q32 that looks in A1:JA1 and returns the largest
date
for the month I entered in P32.

Thank you,

Jeff