• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

Excel WEEKDAY Function

The Excel WEEKDAY function returns the day of the week corresponding to a specified date. The day is retuned as a number from 1 to 7.

The syntax for the WEEKDAY function is:

=WEEKDAY(serial_number, [return_type])

ArgumentPurpose
Serial_numberThe date of the day you are trying to find
Return_typeThe type of value you want returned. This is optional and if omitted, Excel assumes 1.1 – Returns a number from 1 (Sunday) to 7 (Saturday)2 – Returns a number from 1 (Monday) to 7 (Sunday)3 – Returns a number from 0 (Monday) to 6 (Sunday)

The examples below demonstrate the WEEKDAY function being used to calculate the day of the week for the date in the spreadsheet.

The 15 April 2010 is a Thursday.

Excel WEEKDAY function to return the day of the week of a date
FunctionResult
=WEEKDAY(A2)5
=WEEKDAY(A2,2)4
=WEEKDAY(A2,3)3

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • Excel IMAGE Function – Insert Images from a Cell Value
  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·