|
<< Click to Display Table of Contents >> EDATE (date before/after n months) |
Syntax:
EDATE(StartDate, m)
Description:
This returns the date that is m months before/after StartDate. This enables you to determine appointments that fall on the same day of another month.
m is the number of months.
If m is positive, the program calculates a date that is m months after the StartDate.
If m is negative, the program calculates a date that is m months before the StartDate.
m should be an integer. If this is not the case, PlanMaker automatically removes the decimal places.
Example:
EDATE("03/30/2018", 1) returns 04/30/2018
EDATE("03/31/2018", 1) also returns 04/30/2018 because April only has 30 days.
See also: