Rounding to Semi-Annual Dates

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!

Ok, if A1 is the Date
Then where this line is will do that

=IF(MONTH(A1)>6,DATE(YEAR(A1),12,31),DATE(YEAR(A1),6,30))

Explanation:

Month(), Day(), Year() takes a date and takes the number for day, month or year out. and the Date() puts it all back together

Adil

Thanks!

Works like a charm.