Hi H,
.Text = bad
:)
If you mean that the date is on the worksheet as text insead of as a
date(dateserial). if the date matches the system local settings (i.e. date
is in m/d/y format, your computer is set to m/d/y format) you can just use
any of the methods I listed in my last post without any
p.s. oops, so sorry,
though you had posted a new quesiton :) not sure how I got to reading old
posts.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Saturday, June 30, 2012 7:36 PM
To: excel-macros@googlegroups.com
Subject: RE:
No problem. Just to be clear it was the original suggested method that
gave the wrong day.
The format method works fine.
On Saturday, June 30, 2012 7:38:28 PM UTC-7, Asa R. wrote:
p.s. oops, so sorry,
though you had posted a new quesiton :) not sure how I got to reading old
posts…
Hi,
You can use below formula if you don't want to use vba.
=TEXT(C2, )
and if you want to use vba code then use below function
format(cdate(02/05/2012), )
Regards,
Swapnil.
On Wed, Jun 27, 2012 at 9:17 AM, tangledweb domainqu...@gmail.com wrote:
If I already have
You can also change custom format .
Regards,
Swapnil.
On Wed, Jun 27, 2012 at 2:14 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi,
You can use below formula if you don't want to use vba.
=TEXT(C2, )
and if you want to use vba code then use below function
If I already have Sheets(RawData).Cells(count, BarDate).Text having a value
like 6/26/2012 is there a way to get the day of the week as a number or
string for that date that does not require splitting it into its parts and
feeding them to some function? If the latter the .net examples I found