Hi Cheryl,
I saw your post yesterday & didn't quite solve it but your comment "I'm
not even sure what I need to do can be done in Excel. Hopefully, I'm
wrong." provided a little extra motivation ;-)
I think I have it now...
Try entering this:
*cell A1: "=today()"
*cell B1: "8/20/2006" (depending on formatting of cell
*cell C1:
=DATE(YEAR($B$1)+DATEDIF($B$1,$A1,"y"),MONTH($B$1) ,DAY($B$1))
Or to put it all in one cell:
"=DATE(2006+DATEDIF(DATE(2006,8,20),TODAY(),"y"),8 ,20)"
For background on the Datedif function check out Chip's page:
http://www.cpearson.com/excel/datedif.htm
(he includes links to other Date And Time Related Procedures at the
base of the page)
hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=573658