The formula has to do what you asked for. Verify that you copied it
correctly. If you still can't find the error, show us the data. What's in A,
and what result did you get.

Regards,
Fred.

"Sapper" wrote in message
...
Hi Jacob

once I'd looked up the site that you'd recommended, the formula looked
straight forward and logical. Unfortunately, it only reduced the original
date by one day.
When I dragged the formula to B2, I got a strange date which I have been
unable justify

Sapper

"Jacob Skaria" wrote:

Try using the below formula in B1

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

If this post helps click Yes
---------------
Jacob Skaria


"Sapper" wrote:

Hi, I use EXCEL 2003. I have a list a dates in col A. I want to
determine
dates in the future equal to1 day less than the seventyth anniversary
of
those dates. I have seen a formula which is entered on three lines to
return
an answer on a fourth. Problem is the formula is specific to one date.

Is there any formula that I can put in B1, that can be dragged down col
B so
that it will calculate on the corresponding row in col b?

Also I have asked many questions in the past few days, all of which
have
been answered helpfully. Is there a book out there which covers
functions and
syntax in depth?

Thank you