Function: WEEKDAY()

🔍 Purpose:

The WEEKDAY() function returns the day of the week for a given date — as a number (1 to 7).
You can also set which day the week starts on (Sunday or Monday, etc.).

It’s very useful for analysing patterns — like attendance, sales, or billing activities by weekday.

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


Parameters:

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

• return_type → (Optional) A number that defines which day is treated as the first day of the week.

📘 Explanation:

Excel internally stores dates as serial numbers.
When you use =WEEKDAY(A2), it converts that serial into a day code (1–7).
You can then identify whether it’s a Monday, Friday, or Sunday, etc.

🇮🇳 Indian Example 1: Student Attendance Day Tracker

💡 Common in schools or coaching centres to find attendance trends — like how many students come late on Mondays!

🇮🇳 Indian Example 2: Weekly Sales Pattern

📊 Indian retail stores or restaurants often use this to identify which day of the week has the highest sales (like weekends).

⚙️ Real-Life Uses:

• Analyzing sales or expenses by weekday.

• Finding attendance patterns in institutions.

• Determining weekend days to skip in project timelines.

• Generating weekday-based reports for HR, schools, and stores.

🧩 Project Tasks for Students

🧠 Project Task 1: Coaching Centre Attendance Report

You are managing a coaching centre in India. Create a report to check on which day of the week students attend classes.

👉 Bonus: Use an IF formula to mark Sundays:
=IF(TEXT(C2,"ddd")="Sun","Holiday","Class Day")

🧩 Project Task 2: Delivery Service Workload Report

An Indian courier company (like DTDC) wants to know which days of the week have more deliveries.

📦 Then create a bar chart showing deliveries per weekday — perfect for analyzing workload trends.