How to Use the WEEKDAY Function in Excel (video in khmer)

Hello everyone! Today i will show you how to use WEEKDAY formula in Microsoft Excel step by step.

If you have date in your spreadsheet (example: 2026-09-04) and you want to know what day number of week it is (1 for Sunday, 2 for Monday, etc.), the WEEKDAY formula help you very fast and easy!

📚 Related Tutorial: Want to extract day, month, and year separately? Check out How to Use DAY, MONTH, and YEAR in Excel!

🛠️ Formula Syntax

=WEEKDAY(serial_number, [return_type])

• serial_number: The date cell you want to check (example: A2).
• return_type (Optional):
  • 1 (Default): Sunday = 1, Monday = 2 ... Saturday = 7
  • 2: Monday = 1, Tuesday = 2 ... Sunday = 7
  • 3: Monday = 0, Tuesday = 1 ... Sunday = 6

📊 Simple Example

If cell A2 contain date 2026-09-04 (which is Friday):

=WEEKDAY(A2, 1)

• Result: 6 (because Friday is day 6 when Sunday is 1)

=WEEKDAY(A2, 2)

• Result: 5 (because Friday is day 5 when Monday is 1)

💡 Pro Tips for WEEKDAY Formula

1. Get Day Name Text (Monday, Tuesday): If you don't want number and want day name text instead, use =TEXT(A2, "dddd") (example: "Friday").
2. Check Weekend or Workday: You can combine WEEKDAY with IF to check if date is weekend!

   =IF(WEEKDAY(A2, 2) > 5, "Weekend", "Workday")
   

3. Fix Error #VALUE!: If formula return #VALUE! error, check if your date cell is stored as text. Convert cell format to Short Date first.

📚 Related Tutorials

• How to Use NOW() and TODAY() in Excel
• How to Use DATE Function in Excel
• How to Calculate Days Between Two Dates in Excel
• Top 15 Basic Excel Formulas for Beginners