Jan 20 2025 Day Of Week In Excel. For example, january 1st, 2025 is the same as 45658. January 20, 2025 is the 20th day of the year 2025.

In this article, we’ll show you some straightforward ways to get the day of the week from a date, whether you want it as. Using “ddd” will return an abbreviated weekday, such as mon or tue.