Try

=DATE(YEAR(TODAY()),MONTH(TODAY())+6-MOD(MONTH(TODAY())-1,3),1)

Mike

"frrrrrr" wrote:

I'm trying to compose a formula that will give me the date of the nearest
half year. Meaning, if I open the spreadsheet today I'd like to get
1/1/2009. If I open the spreadsheet sometime in January I'd like to get
7/1/2010.

I'd appreciate any help!