AddMonth() function  Previous topicNext topicFirst topicLast topic

AddMonth() function

AddMonth(argument list…)

This function replicates the Edate function in Excel, which advances or reduces a given date number by a user-specified number of months. It's included because early versions of Excel 5 (namely those before version 5.0c) have a bug in Edate. The function uses the following arguments:

Argument Description Restrictions
Base_Date starting date valid Excel date number
Time_in_months months to add to Base_Date integer value

© 1995-98 Leap of Faith Research Inc.