How To (Get) Extract The Name Of The Day Of The Week (In Text) From A Given Date In Excel Explained
In this video we discuss how to extract or get the day of the week in text, from a given date in an excel spreadsheet. We go through a detailed example using the TEXT function
Transcript/notes
Let’s say that you need to extract the day of the week for a given date, such as in this example. To do this, left click on the answer cell, in this example cell B2, then type in a comma. Next, type in te, and a drop down box will appear. In the box, left double click on TEXT.
From here, we left click on the date, cell A2. Next, we type in a quotation marks and then type in 4 d’s for day. Then type in another quotation marks, followed by a parenthesis. Then hit the enter key and we have our answer of Monday.
And this will work for a variety of other types of date formats, as you see here.
Watch video How To (Get) Extract The Name Of The Day Of The Week (In Text) From A Given Date In Excel Explained online without registration, duration hours minute second in high quality. This video was added by user Whats Up Dude 29 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 326 once and liked it 3 people.