Using DATE function

I am trying to determine an end date for a project. The result I am getting is incorrect, and hope someone can review my formula and find the fault.

A1 = 8/27/1997
B1 = 10 (number years in term)
B2 = 0 (number of addtional months)
B3 = -1 (number of additional days)

so, A4=DATE(1997+B1,6+B2,9+B3)

This formula is returning a date of 6/8/2007, I am expecting a date of 8/26/2007.

What am I doing wrong?

Thank you.

Try

=DATE(YEAR(A1)+B1,MONTH(A1)+B2,DAY(A1)+B3)

Thanks Daddy!

Never would have thought to do that.

Happy New Year