To enhance the functionality of your calculator widget, several date functions have been added. These functions allow you to perform various date-related calculations, which can be very useful in applications such as age calculators, loan amortization schedules, and more. Here’s a brief explanation of each function and how to use them.
Date Functions
-
DATE(year, month, day)
- Description: Creates a new date object based on the provided year, month, and day.
- Usage:
DATE(2024, 7, 25) - Example: Returns a Date object for July 25, 2024.
-
TODAY()
- Description: Returns the current date.
- Usage:
TODAY() - Example: Returns today’s date.
-
DATEDIF(startDate, endDate)
- Description: Calculates the difference in days between two dates.
- Usage:
DATEDIF(TODAY(), DATE(2030, 7, 25)) - Example: Returns the number of days between today and July 25, 2030.
-
ADDDAYS(date, days)
- Description: Adds a specified number of days to a date.
- Usage:
ADDDAYS(TODAY(), 10) - Example: Returns the date 10 days from today.
-
ADDMONTHS(date, months)
- Description: Adds a specified number of months to a date.
- Usage:
ADDMONTHS(TODAY(), 1) - Example: Returns the date one month from today.
-
ADDYEARS(date, years)
- Description: Adds a specified number of years to a date.
- Usage:
ADDYEARS(TODAY(), 1) - Example: Returns the date one year from today.
-
YEAR(date)
- Description: Extracts the year from a date.
- Usage:
YEAR(TODAY()) - Example: Returns the current year.
-
MONTH(date)
- Description: Extracts the month from a date.
- Usage:
MONTH(TODAY()) - Example: Returns the current month.
-
DAY(date)
- Description: Extracts the day from a date.
- Usage:
DAY(TODAY()) - Example: Returns the current day of the month.
-
FORMATDATE(date, format)
- Description: Formats a date according to a specified format string.
- Usage:
FORMATDATE(TODAY(), 'YYYY-MM-DD') - Example: Returns the current date formatted as 'YYYY-MM-D