Simple formula to add four months to a date in another cell
I have an Excel worksheet and I have a set of dates in column A.
In column B I want to Excel to add four months to the dates in A - this is so I can have Excel automatically calculate the new date for me.
I've tried working this out, but cannot figure out a simple solution.
Could you let me know the formula I need to use?
thanks
RE: Simple formula to add four months to a date in another cell
Hello Val,
Thank you for your question regarding calaculating dates.
The formula you want is: =date+number(of days)
Date - use cell reference rather than typing in the date manually.
Number(of days) - how many days are in those 4 months?
If the 4 months have 31 days each the number of days is 124.
FORMULA: = date + 124. RESULT: 11/2/13
I hope this helps.
Kind regards
Cindy
Microsoft Office Trainer
