QuitExams

Introduction

Date and Time functions in LibreOffice Calc are used to work with dates, times, and perform calculations such as finding days between dates, extracting parts of a date, or adding months to a date.

1️⃣ TODAY()

Purpose: Returns the current system date.

Formula: =TODAY()

Result: If today’s date is 03-Nov-2025 → 03/11/2025

2️⃣ NOW()

Purpose: Returns the current date and time.

Formula: =NOW()

Result: 03/11/2025 16:45

3️⃣ DAY()

Purpose: Extracts the day from a date.

Formula: =DAY("2025-11-03")

Result: 3

4️⃣ MONTH()

Purpose: Extracts the month number from a date.

Formula: =MONTH("2025-11-03")

Result: 11

5️⃣ YEAR()

Purpose: Extracts the year number from a date.

Formula: =YEAR("2025-11-03")

Result: 2025

6️⃣ WEEKDAY()

Purpose: Returns a number representing the day of the week (1=Sunday, 7=Saturday).

Formula: =WEEKDAY("2025-11-03")

Result: 2 (Monday)

7️⃣ DATEDIF()

Purpose: Calculates the difference between two dates in days, months, or years.

Formula: =DATEDIF("2020-01-01";"2025-01-01";"y")

Result: 5 years

8️⃣ EDATE()

Purpose: Returns the date that is a specified number of months before or after a given date.

Formula: =EDATE("2025-01-15";6)

Result: 15-Jul-2025

9️⃣ EOMONTH()

Purpose: Returns the last day of the month after adding a certain number of months to a date.

Formula: =EOMONTH("2025-02-10";1)

Result: 31-Mar-2025

🔟 HOUR(), MINUTE(), SECOND()

Purpose: Extracts hour, minute, and second from a time value.

Formula Examples:

• =HOUR("14:45:30") → 14
• =MINUTE("14:45:30") → 45
• =SECOND("14:45:30") → 30

📊 Example Table – Date & Time Functions

📘 Practical Example

Below is sample employee data to demonstrate date calculations:

Conclusion

Date and Time functions are vital for time tracking, project planning, and payroll systems. They simplify complex calculations like tenure, deadlines, or scheduling automatically based on system date.