Quarterly month calculation

[Luigi802]

So I'm trying to calculate every 3rd month, (quarterly month). For example today is Aug, I want to create a formula where I input any date in Aug (8/1/2016) and it gives me 11/1/2016, also I want it to continue to reciprocate ever 3rd month automatically, like come 11/1/2016 it will then change to 2/1/2016

 

[Khalid NGO]

Hi,

Use the EDATE function:

=EDATE(A1,3)

where A1 contain today's date.

Regards,

 

[Luigi802]

Hi,

Use the EDATE function:

=EDATE(A1,3)

where A1 contain today's date.

Regards,

I was looking for something more like this
=EDATE(DATE(YEAR(B2),MONTH(B2),1),CHOOSE(MONTH(B2),1,3,2,1,3,2,1,3,2,1,3,2))
Where B2 was today's date. This returns 1 NOV 2016 then doesn't change again until it is NOV then it changes to 1 FEB 2017 which is exactly what I want it to do but I want it to start with Aug

 

[Khalid NGO]

Hi,

I am not getting what you are looking for, can you post some dates with expected results?

Regards,

 

[bosco_yip]

Maybe........

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

Regards