Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 11:35 AM
David
 
Posts: n/a
Default 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   Report Post  
Old November 29th 04, 11:45 AM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old November 29th 04, 12:55 PM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old November 29th 04, 05:08 PM
JulieD
 
Posts: n/a
Default

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   Report Post  
Old November 29th 04, 06:09 PM
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM
Date issue between Windows and Macintosh version dlg1967 Excel Discussion (Misc queries) 4 January 19th 05 03:51 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
Using formulas to determine date in one cell based on date in anot Gary Excel Worksheet Functions 2 November 22nd 04 08:11 AM
calc constant date from variable date & return with ability to rn. SusieQ'sQuest Excel Worksheet Functions 1 November 9th 04 08:51 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017