Try

=DATE(YEAR(A1),MONTH(A1),15)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4))


where A1 holds any day of the particular month you want to check for


--
Regards,

Peo Sjoblom



"DF" wrote in message
ups.com...
Is there a way to find the second Wednesday of each month using Excel
97?