Add # of months and get result last day of # months.
With the start date in A1
=DATE(YEAR(A1),MONTH(A1)+25,0)
format result as date (formatcellsnumberdate)
--
Regards,
Peo Sjoblom
Portland, Oregon
"BDP" wrote in message
...
For aircraft maintenance that is due on the last day of a month, 24 months
from a given date... how can I do it? The FAA requires certain items be
inspected/overhauled, etc. a certain number of months after installation
and
that means we get to go to the end of the month but I don't know how to
take
a date,m add the number of months and get a date that is the last day of
the
resulting month. Any help??
|