EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns in excel.
One is a duration with a year, the other a commencement with year, month and
day.
How do i calculate these two columns to give a future date.
 
Enable the analysis toolkit addin.
In col A give the duration in Month in col B enter the date.
In C1 enter =EDATE(B1,A1)

Format the Col C to date format

Karthik
 
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

Excel Average dates help 0
Count dates until complete or Cancel 5
Calculating Future Value 6
Automatic update to cashflow spread sheet 1
date function 10
Problem with calculating date 6 months into the future 3
identifying data from a separate worksheet 1
selecting a worksheet 2

Back
Top