Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Naming a (date) constant
Greetings & TIA for your help
I can name a constant with Insert|Name|Define then type "MyConstant" and type =500 in "Refers To". How do I enter a date in the "refers to" box? -- David |
#2
|
|||
|
|||
Hi
try for example =DATE(2004,11,29) "David" wrote: Greetings & TIA for your help I can name a constant with Insert|Name|Define then type "MyConstant" and type =500 in "Refers To". How do I enter a date in the "refers to" box? -- David |
#3
|
|||
|
|||
or
=--("2004/11/29") -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try for example =DATE(2004,11,29) "David" wrote: Greetings & TIA for your help I can name a constant with Insert|Name|Define then type "MyConstant" and type =500 in "Refers To". How do I enter a date in the "refers to" box? -- David |
#4
|
|||
|
|||
Hi Bob
(won't even ask how you came up with this one!) but what i will ask is using both yours and Frank's method i'm getting the serial number returned in the cell rather than a "date" ... i know its just a matter of formatting it, but is there anyway when using a date in this way, for excel to "automatically" format it correctly? Cheers JulieD "Bob Phillips" wrote in message ... or =--("2004/11/29") -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try for example =DATE(2004,11,29) "David" wrote: Greetings & TIA for your help I can name a constant with Insert|Name|Define then type "MyConstant" and type =500 in "Refers To". How do I enter a date in the "refers to" box? -- David |
#5
|
|||
|
|||
Julie,
Not to keep it as a date, but you can use =TEXT(--("2004/11/29"),"dd mmm yyyy") which returns it as text, although you can do math on it -- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... Hi Bob (won't even ask how you came up with this one!) but what i will ask is using both yours and Frank's method i'm getting the serial number returned in the cell rather than a "date" ... i know its just a matter of formatting it, but is there anyway when using a date in this way, for excel to "automatically" format it correctly? Cheers JulieD "Bob Phillips" wrote in message ... or =--("2004/11/29") -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try for example =DATE(2004,11,29) "David" wrote: Greetings & TIA for your help I can name a constant with Insert|Name|Define then type "MyConstant" and type =500 in "Refers To". How do I enter a date in the "refers to" box? -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions |