• Date and Time Functions
  • ADDMONTH Function
  • ADDYEAR Function
  • Date and Time Functions
  • 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