In the computer it is easy to know what day of the date given. Open the time and date setting and change the date, month, and year that you want to know, and then the day will appear.
In this post I will tell you how to show the day of the date given in Microsoft Excel.
• Open Microsoft Excel
• Give the name for rows, example : Date and Day
• B2 cell will display name of day automatically depends the value of B1 cell (day,month,year)
so at B2 column we write : =b1 then hit Enter key
• In Format Cells window, choose Number tab then select Custom
• Write dddd in Type column, then click Ok to save configuration
Now you can input the date, and result Day name will appear
The format for entering the date,month and year depends on the cell format, in example above I use default, You can change as you want using format cell menu.
In this post I will tell you how to show the day of the date given in Microsoft Excel.
• Open Microsoft Excel
• Give the name for rows, example : Date and Day
• B2 cell will display name of day automatically depends the value of B1 cell (day,month,year)
so at B2 column we write : =b1 then hit Enter key
• Right-click at B2 cell
• Choose Format cells
• In Format Cells window, choose Number tab then select Custom
• Write dddd in Type column, then click Ok to save configuration
Now you can input the date, and result Day name will appear