Menu
I have to find the Name of a particular DATE (like Sunday, Monday etc.) in past.
Suppose I have to find Day Name on
2000-1-1
How can I find that ?
853
dd – shows the day value from the date in two digits. If the day value is less than 10, a leading zero is added to the number. For example, 5 would become 05. ddd – this will show you the day name in the short format.
Under Category, click Custom, and in the Type box, type dddd for the full name of the day of the week (Monday, Tuesday, and so on), or ddd for the abbreviated name of the day of the week (Mon, Tue, Wed, and so on).
To start, first, open your spreadsheet with Microsoft Excel. In the spreadsheet, make sure you have at least one date. Then select the cell in which you want to display the day of the week. In the selected cell, type the following WEEKDAY function and press Enter.
You can use DATENAME function of SQL Server, like this
SELECT DATENAME(dw,'2000-1-1')
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
