![]() We can also see the Long Date format in the Format Cells Window on the Number tab. Method #2: The Format Cells Dialog Window The keyboard shortcut for the Number Format Drop-down menu is: Alt,H,N,Down ArrowĬheckout my article on how the date system works in Excel to learn more about dates. The Long Date format shows a preview of the date and includes the name of the day for the date in the selected cell. The easiest way to see the weekday name is to select the cell, then press the Number Format Drop-down menu button on the Home tab of the Ribbon. Often times you have a date in a cell and you just want to know the name of the day for the date. Method #1: The Number Format Drop-down Menu This can be very useful for creating summary reports, pivot tables, and charts. ![]() ![]() ![]() In this post we will look at a few different ways to return the day name for a date in Excel. Bottom line: Learn a few different ways to return the name of the day or weekday name for cell that contains a date value. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |