Using Joe's Calendar table, this might provide a way for the kapil to get to the answer he wants.

It removes the need to recursively check if you added another sunday in the extension of the date period

SELECT cal_date FROM Calendar

WHERE julian_business_nbr = (SELECT julian_business_nbr + 30 FROM Calendar WHERE cal_date = '2007-04-05')