Datediff...Issue!!!

[buddy1000]

Hi...

A1 = 05-nov-2007
A2 = =DATEDIF(A1,TODAY(),"m")
The result is 46 complete months.

A3= =EDATE(A1,A2)
The result is 05-Sep-2011.

Is there a way to alter this formula to get complete quarters?
In this case A3 should be 05-Aug-2011

Any ideas?

Thank you....

 

[Yahya]

may be this will help
=EDATE(A1,((TODAY()-A1)/30)+1)

 

[buddy1000]

Hi yaha...

your formula yield 05-nov-2011 and NOT 05-aug-2011

 

[Yahya]

with your formula just Subtract it by 1
=EDATE(A1,DATEDIF(A1,TODAY(),"m")-1)