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