Finding the Weekday of a Date
Key points
- Enter a date
- See the weekday
- Check it
Excel Serial Date shows the weekday along with the date.
Steps
- Enter a date
- See the weekday
- Check it
The remainder of the serial value divided by 7 also gives the weekday.
Use "Excel Serial Number and Date Converter" (free)
Tools that go well with this
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- UNIX Timestamp Converter: Convert between UNIX time and dates.
- Convert Between Western Years and Japanese Eras: Convert between AD years and Japanese eras.