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

Automatic Page Numbers across Multiple Documents

Word allows you to specify the starting page number for a document, which comes in handy if you have multiple documents ...

Discover More

Sorting Text

Word makes it easy to sort the information that is contained in your document. Here's how to accomplish this.

Discover More

Pulling Access Information into Excel

If you have a lot of data stored in Access databases, you may want to get at that information using Excel. There are a ...

Discover More
More DriveTips

Searching for a Term in Sheets

Got a need to search the web for more information on something within a spreadsheet? Believe it or not, Sheets provides a ...

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

Copying a Spreadsheet

There are times when you don't want to mess up a spreadsheet, but you want to try out some changes. This is when making a ...

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 one less than 4?

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?