📅 Excel-7

✨ Project Description

Excel-7 is a guide to working with dates and time in Microsoft Excel. Here you'll find practical tips, instructions, and illustrations about useful functions.

📚 Goal: Help you master Excel's date and time functions for everyday use—whether you're a beginner or advanced user!

---

📚 Table of Contents

• Date Functions
• Current Date and Time
• DATEDIF and Days Calculation
• Calculate Age
• WEEKDAY and Day Names
• NETWORKDAYS and Workdays
• Quarter Calculation
• Screenshots
• Requirements
• Author

---

📆 Date Functions

To enter a date in Excel, use the "/" or "-" characters. To enter a time, use ":" (colon). You can also enter a date and a time in one cell.

ℹ️ Note: Polish date format used here: day.month.year

To extract the year of a date, use the YEAR function.

💡 Tip: Use MONTH and DAY functions to extract month and day.

To add a number of years, months, and/or days, use the DATE function.

If you only need to add days you can do it like this:

---

⏰ Current Date and Time

To get the current date and time, use the NOW function.

ℹ️ Note: Use the TODAY function to enter today's date in Excel.
ℹ️ The result of the NOW function updates automatically whenever the sheet is recalculated.

To extract hour from date use the HOUR function.

💡 Tip: Use the MINUTE and SECOND functions to return minute and second.

To add a number of hours, minutes, and/or seconds, use the TIME function.

---

📏 DATEDIF and Days Calculation

The DATEDIF function in Excel calculates the number of days, months, or years between two dates. It has 3 arguments.

ℹ️ Note:

• Type "d" for the third argument to get days between two dates
• "m" for months
• "y" for years
• "yd" to ignore years
• "md" to ignore months and years

You can also use the DAYS function to achieve the same result:

---

🎂 Calculate Age

We can use DATEDIF to calculate the age of a person:

Use this formula to calculate the exact age:

---

📅 WEEKDAY and Day Names

The WEEKDAY function in Excel returns a number from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date.

We can use the TEXT function with "dddd" format to display that day:

ℹ️ Note: "sobota" means Saturday in Polish.

---

🏢 NETWORKDAYS and Workdays

The NETWORKDAYS function in Excel returns the number of workdays between two dates, excluding weekends (Saturday and Sunday).

---

🗓️ Quarter Calculation

Formula that returns the quarter for a given date:

ℹ️ Note: There's no built-in function in Excel to do this.
ℹ️ ROUNDUP(x,0) always rounds x up to the nearest integer.

---

📸 Screenshots

You can find all screenshots in the /Screenshots folder.

---

ℹ️ Requirements

• Microsoft Excel (recommended: 2021/365 for modern functions)
• Windows OS

---

👨‍💻 Author

Project and documentation by Kuba27x
Repository: Kuba27x/Excel-7

---