Re: Naming a (date) constant

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 18:09:05 -0000

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" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:uBR4OZj1EHA.2572@tk2msftngp13.phx.gbl...
> 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:uXqU0Kh1EHA.1124@tk2msftngp13.phx.gbl...
> > or
> >
> > =--("2004/11/29")
> >
> > -- 
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> > news:1F1E13EE-362F-4D70-9532-A5C111CD1E91@microsoft.com...
> >> 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
> >
> >
>
>