• Date and Time Functions
  • Date and Time Functions
  • ADDMONTH function
  • ADDYEAR function
  • DAY function
  • DAYSTR function
  • DMY function
  • DTOS function
  • FMTDATESTR function
  • ITOD function
  • LDATE function
  • MKDATE function
  • MONTH function
  • MONTHSTR function
  • PERSTR function
  • PERTOJ function
  • SDATE function
  • SDATETOJ function
  • SYSDATE function
  • SYSTIME function
  • VERDATE function
  • VERSION function
  • VERTIME function
  • YEAR function

ADDYEAR Function

The ADDYEAR function returns the new date from a specified Julian date plus or minus a specified number of years.

ADDYEAR(date,# of years)

Example 1

Enter ADDYEAR(c1,1) where cell c1 is formatted as either a date or a numeric cell and contains the function MKDATE(CLP13). CaseView returns a date one year after the client file's year-end.

Example 2

Enter ADDYEAR(c1,-1) where cell c1 is formatted as either a date or a numeric cell and contains the function MKDATE(CLP13). CaseView returns a date one year prior to the client file's year-end.

The function automatically adjusts for leap years and the number of days in each month.

Related Topics

• Date and Time Functions