Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
How do I add a number of months to a date?
Posted by - NA - on 28 March 2006 05:49 AM
|
|
Solution: Suppose your date is in A1 and you want to add 3 months to this date, with the result in B1. Set B1 to =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)). Excel will automatically handle this situation when MONTH(A1)+3 exceeds 12. | |
|
Comments (0)