Thread: constant date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
medavino medavino is offline
external usenet poster
 
Posts: 11
Default 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.