Hi Garry,

Am Tue, 23 Sep 2014 19:49:55 -0400 schrieb GS:

=IF(MONTH(A1)<7,DATE(YEAR(A1),7,1),DATE(YEAR(A1)+1 ,1,1))

Perhaps, though, our local formula wizard Claus will have something
better...

;-)
There are other ways but none so short and clear than yours


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional