Get instant live expert help on how to add months to a date in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

How can add x Months from a beginning date to "now" on an ongoing basis?
Solved by X. C. in 15 mins
I need to conditionally format a cell to highlight when date is five months out from date listed in cell and then six months out from date listed in cell.
Solved by D. J. in 16 mins
I have a column of dates expressed as months ranging from 0 to 100 from today's date in the past. I'm trying to calculate how many of these months are within the past 24 months.
Solved by V. F. in 30 mins
how do conditional format a cell to look at a fixe date in the past and conditional format a colour when the date is 18 months in the past ( amber or green if within 18 months) and 2 years or over (red )
Solved by D. L. in 23 mins
I need a formula to add 3 months to the previous cell. I have hand typed the date in i.e. 30/10/2018 not using the =date formula as i cant seem to get that to work either.
Solved by V. F. in 12 mins