Excel: Adding/Taking n Month(s) to a Date. Add Months to an Excel Date Got any Excel Questions? See Also: Tips Tricks etc Excel: Returning Week Number Excel is often used to work with Dates and it's well suited to do so. One common request is to use Excel to add any desired number of months to a date. For example, if A1 houses the date 31-Aug-2005 you may wish to add (or take) 1 month to that date. There is always going to be controversy as to what number of days should be added/taken to represent a month. This is because not all months have the same number of days.

Excel 2.0 for Windows, which was modeled after its Mac GUI-based counterpart, indirectly expanded the installed base of the then-nascent Windows environment. Excel 2.0 was released a month before Windows 2.0, and the installed base of Windows was so low at that point in 1987 that Microsoft had to bundle a runtime version of Windows 1.0 with.

EDATE The EDATE function/formula is part of the Excel Analysis Toolpak which must be installed for its use. That is, Tools> Add-ins and check Analysis Toolpak. Then you you can use the EDATE function as shown below to add (or take) 1 month to the date in A1 (31-Aug-2005). =EDATE(A1,1) This formula yields a result of 30-Sep-2005.

Not the 31-Sep-2005 as there is no such date! To take 1 month from the same date we would use; =EDATE(A1,-1) This yields the result 31-Jul-2005 which may, or may not be what you expect. Without EDATE The other way that we use will sometimes yield a different result than EDATE.

For example, if we do not use EDATE, but the formula below, we get a result of 1-Oct-2005 even though A1 houses the date 31-Aug-2005. Remember, EDATE gave the result as 30-Sep-2005 =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) As you can see, there are differences with each of the 2 methods. Choose which ones suits your needs best but be aware both methods will not always yield the same result! Got any Excel Questions?

See Also: Tips Tricks etc . Free Choice of OR on all purchases totaling over $64.00. ALL totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to 31 days after purchase date.

$265.61 Buy It Now 3d 19h, CAD $26.56 Shipping Estimate,, 30-Day Returns, Seller: (5,156) 100%, Location: Alpharetta, Georgia, Ships to: Worldwide, Item: 72 New Crucial MX300 1TB SSD Solid State Drive 2.5' Internal CT1050MX300SSD1 1050GB SATA 6.0 SATA III 6Gb/s Fast USPS First Class Mail Shipping Tracking number emailed to your account once your order has been processed Condition: New, Brand: Crucial, Form Factor: 2.5', Model: MX300, MPN: CT1050MX300SSD1, Storage Capacity: 1TB, Interface: SATA III See More. Samsung pm871 512gb 2.5 inch sata 6.0 gbps solid state drive works for mac pro.

Instant Download and Money Back Guarantee on Most Software / Technical Analysis in Excel With $139.00 of FREE software! Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft Some of our more popular products are below. .