Related Topics:

Spreadsheet Mathematical Functions

Data Entry Tips for Functions

WEEKDAY

Description: Returns the day of the week corresponding to a specified date.

Syntax: WEEKDAY(Serial_number, Return_type)

Remarks:

The software stores dates as sequential serial numbers so they can be used in calculations. January 1, 1900 is serial number 1, and January 1, 2011 is serial number 40544 because it is 40,544 days after January 1, 1900. (See the NOW function.)

Example:

If your computer's built-in clock is set to 12:30:00 P.M., 1-Jan-1987, then:

Ten minutes later:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.