Date formula in excel 2007

July 27, 2012 at 02:56:07
Specs: Windows 7
Hi, how to add a sum for a date lets say 2/3/2012, i want a formula which will autopopulate the date automatically to 2/08/2012 that is 2/03/2012 + 5 months, please help

See More: Date formula in excel 2007

Report •

July 27, 2012 at 04:28:47
Search Excel for edate function.

Report •

July 27, 2012 at 11:10:51
Hi manisha.meetun

I am Makarand P from the Dell Social Media and Communities team.

With regards to your question, you have to navigate to Home on Excel, click on Options>Add Ins and select the AutoPak analysis tool and once done, the Edate option would be available for the cell in which you would have entered. Now highlight multiple cells on which you want the dates to auto-populate and enter the formula as (Cell number(month/date/year) and press enter. Dates should come in with the intervals you choose.

Kindly revert for further clarifications,

Thanks and regards,
Dell Social Media Responder

Report •

Related Solutions

Ask Question