• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Day of week

Hi, davinosky!


If you want to get displayed Monday, Tuesday, ..., you can just format the cell (Ctrl-1, Custom, and enter dddd as value). If you want to retrieve the number of day within the week you can use the WEEKDAY function: WEEKDAY(date,type), where type indicates if Monday=0, or 1, or where week starts (you can access the built-in Excel help by clicking in the "f(x)" icon at the left of the edit bar).


Regards!
 
Hi, davinosky!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!
 
Just an extension of the solution provided by SirJB7.


You can use following formula: Assume your date is in Cell D1 or you can replace the cell reference with any date. also the week starts from Sunday.


=choose(weekday(D1,1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
 
You must log in or register to reply here.
Back
Top