One way

=15-WEEKDAY(DATE(A1,5,0),1)

or to return the full date

=DATE(A1,5,15-WEEKDAY(DATE(A1,5,0),1))

where A1 contains the year

Regards,
Peter T


"Charlotte E." <@ wrote in message
...
Can anyone give me a VBA formalua, which will return the date of the
second Sunday in the month of May, given any year?


TIA,

CE