o:excel-macros@googlegroups.com]
On Behalf Of tangledweb
Sent: Thursday, June 28, 2012 10:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Can I get the day of the week (e.g.
Friday) from the date already encoded in a string?
Thanks Asa and belatedly Noorain. The forma
Thanks Asa and belatedly Noorain. The format function worked and as it
happens the other method was returning the wrong day for all those who
might use it.
The .value2 does not seem to be necessary but I left it anyway.
On Wednesday, June 27, 2012 10:09:16 PM UTC-7, tangledweb wrote:
> Asa!
Asa! Good to hear from you. I am fine. Hope the same for you. The
example I posted seemed to work but I admit I did not check to see if
the correct day was returned. Tomorrow I will do that and try out
your format function version (which I think someone else posted
earlier but I had not tried
use Text(a1,"d")
Mothilal
On Wed, Jun 27, 2012 at 12:52 PM, Lalit_Mohan wrote:
> Hi,
>
> Try this revised formula as my last post contain some error
> Evaluate("=Text(Day(""" & Sheets("Sheet1").Cells(count, BarDate).Text &
> """), """")")
>
> Hope it helps you
>
> Regards,
> Lalit Mohan
Hi! Hope you are well.
The "VBA way" is to use VBA's Format function (Replace CELL with the range
object for the cell desired):
Format(CELL.Value2, "")
If you wanted to use the TEXT function, the example given -- I believe --
will return incorrect results. These versions would return
No formula needed :
Just format the cell as ""
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lalit_Mohan
Sent: 27 June 2012 12:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I think, Lalit's Solution is nice..
You can also use..
=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
or
=LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"})
or
in VBA
=Format(A1,"")
--
Thanks & regards,
Noorain An