Calculating a Date in Excel

  • Thread starter Thread starter mmoore9
  • Start date Start date
M

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.
 
Hi mmoore9

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

B1 = Months to add

Hope this helps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating interest due on late loan payments 1
Date Calculation problem 4
calculate 6 months forward from a date 8
If statement with dates 0
Weekend dates conditional format 3
Formula 4
Last Date function 3
Sumproduct count between dates for specific day 7

Back
Top