Function: WEEKNUM()

🔍 Purpose:

The WEEKNUM() function returns the week number of a given date — counting from the start of the year.

For example, if a date falls in the 3rd week of January, WEEKNUM() will return 3.
It’s perfect for tracking weekly progress, sales trends, or project timelines.

🧮 Syntax:  =WEEKNUM(serial_number, [return_type])


Parameters:

• serial_number → The date you want to find the week number for.

• return_type → (Optional) Decides which day the week starts on.

📘 Explanation:

Excel considers Week 1 as the week containing January 1st.
Each week is numbered sequentially — Week 2, Week 3, etc.
Using this, you can group or summarize data by week, which is extremely useful in business analysis, attendance, or production tracking.

Example 1: Weekly Sales Summary

📊 Now, you can easily analyze which week had the highest sales.
This is especially useful for small Indian retailers or weekly offer tracking.

Example 2: Employee Attendance Summary

💡 This helps HR staff create weekly attendance summaries automatically.

⚙️ Real-Life Uses:

• Summarizing sales, production, or expenses by week.

• Grouping attendance or shifts by week number.

• Creating weekly performance dashboards in reports.

• Tracking projects or deliveries based on week cycles.

🧩 Project Tasks for Students

🧠 Project Task 1: Agricultural Produce Tracking

A farmer’s cooperative in West Bengal maintains records of weekly vegetable sales.
Use WEEKNUM() to find the week number and analyze which weeks had better yield.

👉 Use =WEEKNUM(A2,2)
Then, create a Pivot Table to summarize total sales by week.

🧩 Project Task 2: Indian Stock Market Portfolio Tracker

You are creating a weekly analysis sheet for Nifty50 investments.
Use WEEKNUM() to find which week each transaction falls under.

📈 After adding =WEEKNUM(A2,2), you can analyze average profit/loss per week — a great exercise for data analysis students.