Help with formula to go back one year from date in cell

[RobinTMathew]

I have 07/01/2011 in cell a2. What is the formula that I can put in b2 that will return the date one year back in the past? So, I suppose in this case, 07/01/2010?

 

[VoG]

Try

=DATE(YEAR(A2)-1),MONTH(A2),DAY(A2))

 

[RobinTMathew]

I tried the formula below but it returned an error stating it was too few arguments.

=DATE(YEAR(CN2)-1),MONTH(CN2),DAY(CN2))

 

[VoG]

Sorry, I had an extra )

=DATE(YEAR(A2)-1,MONTH(A2),DAY(A2))

 

[RobinTMathew]

Genious. It worked. Thank you!