{"id":4945,"date":"2020-01-27T12:56:54","date_gmt":"2020-01-27T12:56:54","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4945"},"modified":"2024-03-26T10:24:37","modified_gmt":"2024-03-26T10:24:37","slug":"add-or-remove-months-from-the-date-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/add-or-remove-months-from-the-date-in-excel\/","title":{"rendered":"Add or Remove Months from Date in Excel"},"content":{"rendered":"\n
If you want to add months to a date, you can use the EDATE<\/strong> function. It returns a date the N\nmonths in the past or future. <\/p>\n\n\n\n Here’s how the syntax looks like.<\/p>\n\n\n\n Take a look at the following example.<\/p>\n\n\n\n If A1<\/strong> contains\nthe following date:<\/p>\n\n\n\n December 25, 2019<\/strong>,\nyou can see the date 2 months into the future. By default, it will return the\nserial number. If you read my article on how Excel\nstores dates<\/a>, you will know why it is the case.<\/p>\n\n\n\n=EDATE (start_date, months)<\/code><\/pre>\n\n\n\n
Add months to a date<\/h2>\n\n\n\n