Amazing Excel tricks 👏 Excel tips and tricks to boost your productivity Excel, Excel tips, Excel tricks, Excel Tutorials, Excel functions and formula #Excel #exceltips #exceltricks #exceltutorial #excelshorts #msexceltutorials #msexcel #msexceltricks #msexceltips #excelfunctions #AdvanceExcel | Vision Computers

In this tutorial, you will learn how to calculate day of week in #Excel by using the TEXT function. If your date is on A2, click on B2. Type =TEXT((A2), "ddd"). Press "Enter". This will display the calculation. ddd will give you the first three letters of the weekday name. Double-click on the bottom-right corner of the cell to apply the formula to the rest of the cells in the column. dddd will give you the full day name. d will give you the date. mmmm will give you the full month name. yyyy will