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.