How to use WEEKDAY and WEEKNUM formula in Excel with Example Download
How to use WEEKDAY and WEEKNUM formula in Excel with Example Download
If you have list of dates and want to display monday or tuesday ... from the date,WEEKDAY function in Excel is used to get the day (mon,tue,wed,...) of the week from input date.WEEKNUM is used to return numbers of the week from date.
WEEKDAY formula in Excel
WEEKDAY returns number from the given date, number range from 1 (sunday) to 7 (saturday) by default but we can set the setting as we want.FORMULA:
=WEEKDAY(serial_number,[return_type])
◾ serial_number: Required, is date as input.
◾ [return_type]: Optional, let see options below.
| return_type | Output result |
|---|---|
| 1 or omitted | Numbers 1 (Sunday) through 7 (Saturday). |
| 2 | Numbers 1 (Monday) through 7 (Sunday). |
| 2 | Numbers 0 (Monday) through 6 (Sunday). |
| 11 | Numbers 1 (Monday) through 7 (Sunday). |
| 12 | Numbers 1 (Tuesday) through 7 (Monday). |
| 13 | Numbers 1 (Wednesday) through 7 (Tuesday). |
| 14 | Numbers 1 (Thursday) through 7 (Wednesday). |
| 15 | Numbers 1 (Friday) through 7 (Thursday). |
| 16 | Numbers 1 (Saturday) through 7 (Friday). |
| 17 | Numbers 1 (Sunday) through 7 (Saturday). |
WEEKNUM formula in Excel
WEEKNUM returns the week number of any input date.FORMULA:
=WEEKNUM(serial_number,[return_type])
◾ serial_number: Required, is date as input.
◾ [return_type]: Optional, refer to video below for detail.
Watch How to use WEEKDAY and WEEKNUM formula in Excel speak Khmer
No comments: