Date Time Values 1

[rpg121]

I have a list of Date Time Values in a list and I need to find a way to return a value of a date, not just view the date such as in formatting the cell but the value of the cell needs to be the written date. For example:

I have 38165 in a cell (the cells returns 6/27/2004). I need the cell beside it to have a value of June 27, 2004. Is there a way to do this? Thank you.

 

[PHV]

Something like this ?
ActiveCell.Offset(0, 1).Value = Format(ActiveCell, "MMMM D, YYYY")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[rpg121]

That didn't work.
The reason I need to get away from the Date-Time code is because I have cells on another page that concatenate two dates and put a hyphen between them.

"=Config!E2 & " - " &Config!E8"
comes out now as this:
38165-38171

I need it to come out as this:
June 27, 2004 - July 3, 2004. (Format doesn't really matter, I just need something that the ordinary person can read)

I can't just have someone manually type in the dates, because the whole thing is automated.

 

[PHV]

Something like this (not VBA related) ?
=TEXT(Config!E2, "MMMM dd, yyyy") & " - " & TEXT(Config!E8, "MMMM dd, yyyy")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[rpg121]

Beautiful! Works amazing!

Thanks for your help.