cell date value

[greg]

OK,
this must be an easy one.
I have a named cell. Start_date
The cell is formated as date. with a date value 7/1/2010
when trying to get the cell value I do not get the date
range("start_date").Value2
It comes out:
40360

so must be something easy.
anyone have an answer?
thanks

 

[Rick Rothstein]

Why are you using Value2? Try using this...

Range("Start_Date").Value

Or, you can format the date value from Value2 yourself....

Format(Range("Start_Date").Value2, "m/d/yyyy")

 

[Mike H]

Greg,

Try this

Mydate = Format(Range("start_date"), "dd/mm/yyyy")

Mike

 

[Jacob Skaria]

Try

=Format(range("start_Date"),"dd-mm-yyyy")

If this post helps click Yes

 

[greg]

Thanks
What is the diff between value and value2?

 

[Rick Rothstein]

From the Remarks section of the VBA Help Files for Value2...

"The only difference between this property and
the Value property is that the Value2 property
doesn't use the Currency and Date data types."

The fastest way to check a keyword out in the VBA Help Files is to type the
word in any code window and, with the text cursor in or next to the word,
press F1.

 

[greg]

thanks all

Try

=Format(range("start_Date"),"dd-mm-yyyy")

If this post helps click Yes