Convert one date unit to week of year like "Monday".

Input

Output

28 Related tools

Table Statistic?

Any Questions?

Convert one date unit to week of year like "Monday". Refers to the name of the day in a week for a specific date within a year. Read more about weekday of year on Wikipedia https://en.wikipedia.org/wiki/Calendar_date

The 60th day of 2022 (a non-leap year) is a Tuesday.

Some analyses or operations are based on weekdays. Retail managers assessing sales can convert dates to weekdays, comparing sales or trends across specific days, aiding in inventory or staffing decisions.

  • Microsoft Excel:
  • Google Sheets:
  • Apple Numbers:
  • Python Pandas: df['date'].dt.weekday
  • Related Words: find weekday, week day name, day of the week

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.