View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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