What excel formula can I use to calculate a maturity date by having a specific date in cell A1, and a number that will represent how many months to calculate forward in cell A2, with end date result in cell A3?
Example: February 1, 2013 12 January 1, 2014
edit: Moved to other forum. Don't even know why this ended up on this site.
Hey Guys i think that for setting the date range on excel you should able to perform the calculations just like others.For such performing its necessary to identify a due date like a start date and also the no of days in a date range of excel.You should using "-" and "+" for calculating the range period finishing date.Thanks a lot!!