Function: DAY()

📘 Definition:

The DAY() function in Excel returns the day of the month (a number between 1 and 31) from a given date.

It helps you extract just the day portion from a complete date — very useful for reports, scheduling, and filtering based on specific days.

DAY(serial_number)

serial_number → The date value (either a real Excel date or a cell reference containing a date)

Example (Indian Perspective):

This extracts only the day part of each important Indian national holiday date 🇮🇳.

🪜 Step-by-Step Explanation:

1. Suppose A2 = 15-Aug-2024

2. Formula → =DAY(A2)

3. Excel reads the date and returns 15, the day of that date.

4. You can use it for grouping or filtering all records from specific dates (like 1st, 15th, or 30th of each month).

💡 Tip:

If you have a text-based date like "15-Aug-2024", you must first convert it using DATEVALUE():

🎯 Why It’s Useful:

• To analyze daily trends (like all sales on the 15th of each month).

• For separating Day, Month, and Year from a full date.

• For custom date formats or conditional logic based on day numbers.

🧑‍💻 Project Task 1: Analyze Daily Sales Patterns

👉 Tasks:

1. Use DAY() to extract the Day of Month for each invoice.

2. Create a Pivot Table to check which day appears most frequently.

3. Which day (1–31) generates the most invoices?

🧑‍💻 Project Task 2: Student Birthday Month Analysis

👉 Tasks:

1. Use DAY() to extract the Birth Day from the DOB.

2. Find how many students have birthdays on the 1st, 5th, 12th, etc.

3. (Optional) Combine with MONTH() later to sort birthdays by full date.