constant date

  • Thread starter Thread starter medavino
  • Start date Start date
M

medavino

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.
 
why not copy and paste special values?

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



"medavino" escreveu:
 
Insert today's date in A1 by hitting CTRL + semicolon.

Your formula is then =A1 + 42


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I subtract todays date from range of dates 1
Date functions 2
Can I update a date formula only if checkbox changes? 1
Excel Message box with days of month & date. 1
Excel Colour code dates 1
Excel 2003 make 1 date cell automatically change another date cell 3
Excel Average dates help 0
Date function 11

Back
Top