Calculating a Date in Excel

[mmoore9]

Is there a way to calculate a future dat in excel so that the result
of the calculation is the first of the next month. I need to be able
to calculate 6 months from a date and then identify the 1st of the
next month. For example: Current date: 07/22/04
6Months: 01/22/05
1st of the next month: 02/01/05

Thanks.

 

[Andrew]

Hi mmoore9

=DATE(YEAR(A1),MONTH(A1)+B1,1)

B1 = Months to add

Hope this helps

 

[Frank Kabel]

Hi
try
=DATE(YEAR(A1),MONTH(A1)+7,1)