If you check the original post, the brackets are correct. You added two
brackets to the formula given. So you must have added one at the start,
which resulted in an Excel error, then fixed it by adding another.

You'll save yourself a lot of trouble if you copy the formulas given rather
than retyping them.

Regards,
Fred.

"Sapper" wrote in message
...
Hi Fred

Ithink there was a bracket missing from original post

formula below worked

Thanks for input

Sapper

=DATE((YEAR(D9)+70),MONTH(D9),DAY(D9)-1)