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

Table Numbers are Skipped

What do you do if you add numbered captions to an element of your document (such as tables) and Word skips a number? ...

Discover More

Changing Borders for Data Series

Microsoft Graph allows you to easily add charts to a Word document without using Excel. This tip explains how you can ...

Discover More

Figuring Out Your IP Address

If you computer communicates over a network or over the Internet, it uses an IP address. This tip explains what an IP ...

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

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

Creating a Named Range

Named ranges can be a great boon in creating easily understandable formulas. Here's what they are an how to define them.

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 seven more than 3?

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?