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

Creating a Document Clone

If you need to work with a copy of a document rather than the original document, you can use Word's Open dialog box to ...

Discover More

Counting Groupings Below a Threshold

When analyzing data, you may need to distill groupings from that data. This tip examines how you can use formulas and macros ...

Discover More

Viewing Comments

Adding comments to a document is a normal activity when writing and editing. Once comments have been added, you may wonder ...

Discover More
MORE DRIVETIPS

Filling Cells

If you need to fill information into a range of cells, one of the fastest ways of doing it is to use the fill handle. This ...

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

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 you ...

Discover More

Comments for this tip:

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. 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 three minus 1?

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?


Links and Sharing
  • Ask a Question
  • Make a Comment
  • Free Business Forms
  • Free Calendars
  • Share