How to get day of the week in Microsoft Excel / How to use WEEKDAY Function (Formula) in Microsoft Excel



WEEKDAY

Use of WEEKDAY Function/Formula in Microsoft Excel:


This formula returns the day of the week for given date.


Syntax/Formula:

Syntax of WEEKDAY function in Microsoft Excel is below.

=WEEKDAY(date, return_type)


Example 1:

Step 1: First type any date for Ex. 25-12-1955 in cell B5.

Step 2: Type formula =WEEKDAY(B5,1) in cell B8 and press enter.


WEEKDAY


Example 2:

Step 1: First type any date for Ex. 28-12-1955 in cell B5.

Step 2: Type formula =WEEKDAY(B5,1) in cell B8 and press enter.


WEEKDAY

No comments:

Post a Comment