| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract a variable no. of mos. from a constant date? in excel | Excel Discussion (Misc queries) | |||
| Searching a date range to output values according to a constant. | Excel Discussion (Misc queries) | |||
| Build an array constant with DATE function | Excel Worksheet Functions | |||
| Naming a (date) constant | Excel Worksheet Functions | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
Linear Mode
