Date field

[Erin]

I would like to formulate J2 to say: the first of the
month for the following quarter (Jan 1, April 1, July 1,
October 1), based on cell I2 which is the date to go off
of.

How do I do this? Is it possible?

Thanks,

 

[JE McGimpsey]

One way:

=DATE(YEAR(I2),INT((MONTH(I2)-1)/3)*3+4,1)