The EDATE function allows you to move a set number of months forward or backward in time based on a specified date.
Suppose we need to calculate warranty expirations based on the 14 months from the date of purchase.
The formula(s) would appear as follows:
=EDATE(A3, 14)
If you need to calculate N-number of months in the past, define the “Months” argument as a negative value.
=EDATE(A3, -14)
If you wanted to be generous with your warranties and allow a grace period to the end of the 14th month, you could nest the EDATE function within in EOMONTH function.
=EOMONTH(EDATE(A3, 14), 0)
ليست هناك تعليقات:
إرسال تعليق