Determining the Day of the Week

by Allen Wyatt
(last updated December 26, 2013)

2

There may be times when you need to figure out what day of the week a particular date represents. For instance, the day of the week for December 26, 2013, is Thursday. You can use figure this out by using the WEEKDAY function, in this manner:

=weekday(A7)

Assuming that cell A7 contains a date, the function returns a value of 1 through 7, representing the day of the week beginning with Sunday. (Sunday is 1, Monday is 2, etc.) This means that if A7 is December 26, 2013, then the function returns the number 4, which represents Thursday.

If you want to start counting with Monday (where Monday = 1) instead of Sunday, you can use the following:

=weekday(A7, 2)

Finally, you can specify that you want to start with Monday but return a value of 0 through 6. This can be done using this variation of the function:

=weekday(A7, 3)

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Changing Orientations within a Single Printout

Excel allows you to print out information in either portrait or landscape orientation, but what if you need both types of ...

Discover More

Inserting the Document Title in Your Document

One of the pieces of information you can store with a document is the title of that document. Using fields, you can then ...

Discover More

Changing the MAC Address for a Network Adapter

MAC addresses are used to uniquely identify devices on your network, such as a network adapter. Here's how you can modify ...

Discover More
More DriveTips

Changing Vertical Cell Alignment

If you have a large row height, you may want to adjust how the information in a cell is aligned vertically. Sheets allows ...

Discover More

Adjusting Cell Alignment

To present your spreadsheet data in just the manner you want, Sheets provides tools that enable you to adjust both ...

Discover More

Using Find and Replace in a Spreadsheet

As your spreadsheets get larger, it can be hard to find some information. You may also want to replace some existing ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 0?

2016-02-02 12:33:57

H Ritenour

Why is the DAY function in sheets off by one day -1?


2013-12-26 06:34:49

JD Murphy

How about 16 October 1854?