Get instant live expert help on I need help with excel add months to date

“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 tried to convert a value into date but excel gave me a unique string referencing months and years instead.
Solved by V. B. in 19 mins
hi, I need a formula to calculate monthly storage costs starting 3 months after the fabrication date. i.e fabrication date 1/1/18, today (5/6/18) would equal £300 (3 months free, £100 each. is this possible on excel? thanks Mary
Solved by V. H. in 24 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