Pete,

That works for me. Thanks.

Now is there a way to make it look for mm/yyyy instead of a single date.
There will be times when I need to see the whole month instead of a single
day.

The date in the cell will be in this order: mm/dd/yyyy

"Pete" wrote:

How about:

=IF(A2=C$1,B2,"")

entered into C2 and copied down as necessary.

Hope this helps.

Pete