On 9/24/2012 11:58 AM India Time, _Swapnil Palande_ wrote:
And if you don't want to use formula then use custom format of cell as
"ddd"
oh, that is even more easy.
but, as the main date is visible in other cell, from which i want to
show cdow in this cell, I guess the other formula sent by y
And if you don't want to use formula then use custom format of cell as "ddd"
On Sep 24, 2012 11:55 AM, "Swapnil Palande"
wrote:
> Hi,
>
> Use TEXT function.
>
> Ex: =text(A2, "ddd")
> On Sep 24, 2012 11:46 AM, "V S Rawat g" wrote:
>
>> Is there a function in excel 2013 that would give character
Hi,
Use TEXT function.
Ex: =text(A2, "ddd")
On Sep 24, 2012 11:46 AM, "V S Rawat g" wrote:
> Is there a function in excel 2013 that would give character day of week
> (e.g Mon, Tue...).
>
> Weekday function is giving numeric day, what is the fun of it. do we need
> to write another function or
Dear VS,
You can use it for weekday as Character day of week.
=CHOOSE(WEEKDAY(A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
or
=LOOKUP(WEEKDAY(A2),{1,2,3,4,5,6,7},{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"})
see attached sheet for more clarity.
On Mon, Sep 24, 2012 at 11:45 AM, V S Rawat g
Is there a function in excel 2013 that would give character day of
week (e.g Mon, Tue...).
Weekday function is giving numeric day, what is the fun of it. do we
need to write another function or macro just to convert this numeric
day to sun, mon...
Thanks.
--
Rawat
--
Join official facebook
