Because that would add 69 days to the date. The OP wanted to add 70 *years*
to the date, then subtract one day.

Regards,
Fred.

"edvwvw via OfficeKB.com" <u42512@uwe wrote in message
news:9547bc4230519@uwe...
Why not =A1+69 format cell B1 as date

edvwvw



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

--
Message posted via http://www.officekb.com