Jody,
If the current date is in A1 from a key-in, reference from another cell
or using NOW(), then in B2 place =A1+45. This will show a calendar
date 45 days after the date shown in A1. Should A1 change, B1 will
change accordingly. Be sure the cells are formatted the same from the
many Date choices in the Format drop-down.
I hope I interpreted your problem properly. GeorgeF


--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124
View this thread: http://www.excelforum.com/showthread...hreadid=465963