#Formula for week number in excel serial
I want the day to be displayed as Sun, Mon, Tue, Wed, Thur, Fri, and Sat instead of a serial number, then choose function is used along weekday function to get the output Suppose I want the name of that numeric value for the output of weekday function, i.e. Usually, WEEKDAY Function in Excel returns the value or output as a serial number.
![formula for week number in excel formula for week number in excel](https://cdn.educba.com/academy/wp-content/uploads/2019/03/Week-Numbers-example-1-2.png)
In the “E8” CELL, the WEEKDAY Function returns the day of the week corresponding to November 16 th, 2018, i.e. Return_type: I entered here as 1, 1 is a default value, where it considers 1 for Sunday to 7 for SaturdayĬlick ok after entering both the arguments.
![formula for week number in excel formula for week number in excel](http://i.ytimg.com/vi/MPMuW0P3PPI/maxresdefault.jpg)
Here I mentioned the reference cell, i.e. Serial_number is the date or reference cell or date in number format, either of them is entered to get the desired output. Select the cell “E8” where weekday function needs to be applied, Click the insert function button (fx) under formula toolbar, a dialog box will appear, type the keyword “WEEKDAY” in the search for a function box, WEEKDAY Function will appear in select a Function box.ĭouble click on WEEKDAY Function, A dialog box appears where arguments for WEEKDAY Function needs to be filled or entered i.e.
![formula for week number in excel formula for week number in excel](https://cdn.ablebits.com/_img-blog/weeknum/excel-month-by-week-number.png)
Let’s apply the WEEKDAY Function in cell “E8”. Prior to applying the weekday function, if the “E8” cell is in date format, we have to convert that cell format into the general format. With the help of the weekday function, I need to find out a day of the week in the cell “E8.” You can download this WEEKDAY Function Excel Template here – WEEKDAY Function Excel Template Example #1