On Mon, 8 Aug 2005 09:56:08 -0700, "SharonP."
wrote:
Can someone help with a formula to calculate ending dates?
For example, I have a beginning date of 01/01/2006 and need to determine an
ending date. I need to figure an input variable that has been selected - 12
months
or 15 months. ie. if beginning date is 01/01/2006 - it needs to calculate
12 months from that date for an ending date of 12/31/2006.
Is this a table and vlookup situation or a formula?
=EDATE(Start_date, Num_Months)
--ron
|