{"id":782,"date":"2012-10-15T11:42:03","date_gmt":"2012-10-15T11:42:03","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=782"},"modified":"2023-12-30T23:12:17","modified_gmt":"2023-12-30T23:12:17","slug":"how-to-add-months-to-a-date-in-excel-2010","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-add-months-to-a-date-in-excel-2010\/","title":{"rendered":"How to add months to a date in Excel 2010 using a simple formula"},"content":{"rendered":"<p>In one of my earlier blog posts, I looked at how an Excel formula can add working days to a date. \u00a0This was for a manager who wanted to set up deadlines for the tasks to be completed within the team&#8217;s appraisal meetings.<\/p>\n<p>I want to build on this and find out how to add a number of months to a date. \u00a0I was feeling brave, but despite my best efforts, I spent ages trying to figure it out, and then resorted to asking the trainer for advice via our forum.<\/p>\n<p>So back to my example of the manager who wants to add follow up meeting dates.<\/p>\n<ul>\n<li>He has conducted the appraisal meetings with each team member, and at that meeting he has agreed a review date for each team member.<\/li>\n<li>He has decided to sets their review date in 3 months.<\/li>\n<\/ul>\n<p>Here is the worksheet ready for the formula:<\/p>\n<figure id=\"attachment_795\" aria-describedby=\"caption-attachment-795\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/appraisal-follow-up-excel-sheet1.png\"><img decoding=\"async\" class=\"size-medium wp-image-795\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/appraisal-follow-up-excel-sheet1-300x91.png\" alt=\"appraisal-follow-up-one-day-excel-course-london\" width=\"300\" height=\"91\" \/><\/a><figcaption id=\"caption-attachment-795\" class=\"wp-caption-text\">The appraisal meeting date is set, and now the manager wants to add a follow up meeting in three months.<\/figcaption><\/figure>\n<p>The easiest way to add three months to the meeting date is to use a formula with the <strong>months expressed as number of days<\/strong> (3 x 31 days = 93).<\/p>\n<p>So the formula will be = the meeting date in column F + 93 days.<\/p>\n<p>The manager can add the formula to the first team member&#8217;s details, and then copy the formula down the column for the remaining staff. \u00a0The first row will be =F3+93<\/p>\n<figure id=\"attachment_796\" aria-describedby=\"caption-attachment-796\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/add-three-months-to-date-one-day-excel-course-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-796\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/add-three-months-to-date-one-day-excel-course-london-300x222.png\" alt=\"add-three-months-to-date-one-day-excel-course-london\" width=\"300\" height=\"222\" \/><\/a><figcaption id=\"caption-attachment-796\" class=\"wp-caption-text\">The manager has added the formula so the follow up meeting dates are automatically updated.<\/figcaption><\/figure>\n<p>If the manager has to reschedule the appraisal meeting date, the formula will automatically update the follow up meeting date. \u00a0Phew.<\/p>\n<p>If you are looking to get more out Excel formulas and functions, these are included for all levels in our one day course Excel London. \u00a0<a href=\"https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php\">https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php<\/a><\/p>\n<p>&nbsp;<\/p>\n<dl>\n<dt><\/dt>\n<\/dl>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In one of my earlier blog posts, I looked at how an Excel formula can add working days to a date. \u00a0This was for a manager who wanted to set up deadlines for the tasks to be completed within the team&#8217;s appraisal meetings. I want to build on this and find out how to add [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[200,401],"class_list":["post-782","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-formulas","tag-one-day-course-excel-london"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=782"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/782\/revisions"}],"predecessor-version":[{"id":6720,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/782\/revisions\/6720"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}