You are here: Help Topics > Customization > Calculation > ADDMONTH Function

ADDMONTH Function

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

ADDMONTH(date,# of months)

Example 1

Enter ADDMONTH(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 month after the client file's year-end.

Example 2

Enter ADDMONTH(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 month 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