Hello All,

Should be a quick one for you guru's. I need to round some dates to the nearest semi-annual date for that year.

Ex. - 4/31/2007 = 6/30/2007.
Ex. - 9/30/2007 = 12/31/2007.

There are dates from 2006 and 2005 as well. I was trying to find something similar to '=EOMONTH' for semi-annual dates, but to no avail.

Thanks!