WEEKNUM function

---

Function Type:

Date and Time

---

Description:

WEEKNUM function in Excel or Google Sheets Converts a serial number to a number representing where the week falls numerically with a year. This function is useful in formulas when you need to know the week number, especially when you’re in the middle of the year where it gets confusing to keep track. I mostly use this on Dashboards/Summary computations involving annual or weekly performance.

In my head, WEEKNUM is short for WEEK NUMber.

---

Function Structure: 

=WEEKNUM (serial_number, [return_type])

---

Argument Breakdown:

serial_number – A valid Excel date in a serial number format.

[return_type] – You can specify the day the week begins. Default is 1 when omitted.

Options:
1 – Sunday /
2 – Monday / 11 – Monday / 12 – Tuesday / 13 – Wednesday / 14 – Thursday / 15 – Friday / 16 – Saturday / 17 – Sunday / 21 – Monday

---

Example:

https://images.hive.blog/DQmZ7Evd7kn6GUkomDqs4CnDwNmcUh4ShUCKMagu4DqrvZj/image.png

---

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->