constant date
 

i am using excel 2003. i need to take today's date and add 6 weeks to it
(+42) and have that date remain constant.
if i use now or today, date changes each time i open spread sheet or refresh
it.
thanks.

constant date
 

why not copy and paste special values?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"medavino" escreveu:

i am using excel 2003. i need to take today's date and add 6 weeks to it
(+42) and have that date remain constant.
if i use now or today, date changes each time i open spread sheet or refresh
it.
thanks.

constant date
 

=DATE(2007,1,14)+42


"medavino" wrote:

i am using excel 2003. i need to take today's date and add 6 weeks to it
(+42) and have that date remain constant.
if i use now or today, date changes each time i open spread sheet or refresh
it.
thanks.

constant date
 

Insert today's date in A1 by hitting CTRL + semicolon.

Your formula is then =A1 + 42


Gord Dibben MS Excel MVP

On Mon, 14 Jan 2008 08:43:04 -0800, medavino
wrote:

i am using excel 2003. i need to take today's date and add 6 weeks to it
(+42) and have that date remain constant.
if i use now or today, date changes each time i open spread sheet or refresh
it.
thanks.