Using Date Functions in Your Calculator Widget

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

1. 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.

2. TODAY()

   • Description: Returns the current date.
   • Usage: TODAY()
   • Example: Returns today’s date.

3. 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.

4. 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.

5. 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.

6. 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.

7. YEAR(date)

   • Description: Extracts the year from a date.
   • Usage: YEAR(TODAY())
   • Example: Returns the current year.

8. MONTH(date)

   • Description: Extracts the month from a date.
   • Usage: MONTH(TODAY())
   • Example: Returns the current month.

9. DAY(date)

   • Description: Extracts the day from a date.
   • Usage: DAY(TODAY())
   • Example: Returns the current day of the month.

10. 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