One way,

Returns the second sunday for any valid date in a1

=DATE(YEAR(A1),MONTH(A1),7+CHOOSE(WEEKDAY(DATE(YEA R(A1),MONTH(A1),1)),1,0,6,5,4,3,2))

Mike

"Charlotte E." wrote:

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