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

Wrong Characters Printed in Equations

Ever have the problem of your document printing different characters than what appears on the screen? There are several ...

Discover More

Changing Decimal Commas to Decimal Points

If you have a document that was produced in a country where decimal commas are used instead of decimal points, you may be ...

Discover More

Out of Kilter Borders

Borders not printing properly? It could be any one of a number of reasons causing the problem. This tip provides some ...

Discover More
More DriveTips

Adding a Drawing to Your Spreadsheet

Numbers alone do not define spreadsheets. Google Drive allows you to also add drawings to a spreadsheet, which can be ...

Discover More

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

Transposing Information in a Sheet

If you want to turn a range of cells by 90 degrees within a spreadsheet, you need to understand how Sheets can handle the ...

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 2?

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?