Hi, I was looking for a cell formula that returns the next January 1 or July 1 after a given date.

Examples:

3/8/2013 would return 7/1/2013

or

8/21/2014 would return 1/1/2015

Here is a formula for returning the first day of the next quarter (provided by "Bernd P") - but I wasn't able to tweak it to return the next Jan. 1 or July 1:

=DATE(YEAR(A1),1+FLOOR(MONTH(A1)+2,3),1)

Thanks.