Thank you, how does it know that the -1 refers to days?

"Dave Peterson" wrote:

=EDATE(Start_date, Num_Months)-1

If I understood correctly.

SharonP. wrote:

Thank you, I've tried this and it works great. One more question,
is there a way to do Num_Months minus 1 day?

"Ron Rosenfeld" wrote:

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


--

Dave Peterson