Hi, I have a series of dates in a column in MS Excel 2010. All the dates are different, and I have hundreds of dates, but I need to add 6 months + 1 day to each date and get the new date once that calculation has been done. So, as an example, lets say I have a date of 01/01/2015. I need to add 6 months to it and 1 extra day. So, mathematically, it would be (01/01/2015 + 6 months + 1 day) = New date.
The new date is what is important to me to make a determination.
Your help is greatly appreciated.