Adding # of Months to calculate a Date

[smalik]

Is there a way to add # of months to a date and then find out what would be the exact date?

For example if cell A1 = 04/30/07 and Cell B1 = 14 what is the statement that would give me 06/30/08 in Cell C1?

Also, how can I modify the statement if Cell B1 = 14.5 to get 07/15/08?

Any help is greatly appreciated.

 

[Yogi Anand]

Hi Gene:

In the last example we started off with 30-Apr-07 and pushed it forward 1 month at a time. EDATE did its job by pushing the date forward by 1 month and when the total number of months in a month were less than the day of the starting date, it used the maximum number of days on the month under consideration. See the illustration below with the starting date as being 31-Mar-07 ...

y070729h1.xls
	A	B	C	D
1	3/31/2007	14	5/31/2008
2
3		MonthIncrement	Using Date(Year,Month,Date)	Using EDATE
4		1	5/1/2007	4/30/2007
5		2	5/31/2007	5/31/2007
6		3	7/1/2007	6/30/2007
7		4	7/31/2007	7/31/2007
8		5	8/31/2007	8/31/2007
9		6	10/1/2007	9/30/2007
10		7	10/31/2007	10/31/2007
11		8	12/1/2007	11/30/2007
12		9	12/31/2007	12/31/2007
13		10	1/31/2008	1/31/2008
14		11	3/2/2008	2/29/2008
15		12	3/31/2008	3/31/2008
16		13	5/1/2008	4/30/2008
17		14	5/31/2008	5/31/2008
Sheet1 (2)

 

[mortgageman]

I completly follow your example. I still think, however, that the case can be made for "last day" to always go to "last day", regardless if one month can "fit into" ( <= quoting myself cuz that's how I understand what you said) another month.