98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Simple formula to add four months to a date in another cell
Simple formula to add four months to a date in another cell
Resolved · Low Priority · Version 2010
Tue 9 Oct 2012, 15:26Trainer Val said...
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
Wed 10 Oct 2012, 11:17Trainer Cindy said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted. |
