• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Adding Months to a Date in Excel

0 Comments

Similar to adding years to a date, you can add months to a date to get a future date, or subtract months to get a past date. In this tutorial, we will cover various methods with multiple examples.

Adding a Month to a Date (Using the EDATE Formula) To get the exact date for the next month, we can use the EDATE formula. Let’s say we have a date in cell A1 and we want to find the date for the next month.Date in Excel 1

Adding Months to a Date in Excel

Follow these steps:

  1. In cell B1, enter the formula “=EDATE(“
  2. Refer to cell A1 where you have the date.
  3. In the second argument, enter the number of months you want to add. For the next month, enter 1.
  4. Type a closing parenthesis and hit enter.

The result will be the date for the next month in cell B1, which is exactly 1 month ahead of the original date.Date in Excel 2

Example: =EDATE(A1,1)Date in Excel 3

Adding 6 Months to a Date Similarly, we can add 6 months to a date to get a date that is 6 months ahead of the current date. For example, if we have the same date in cell A1 as before, to add 6 months we can use the following formula:

Example: =EDATE(A1,6)Date in Excel 4

Adding 3 Months to a Date To add 3 months to a date, we can use the EDATE formula in the same way as before:

Example: =EDATE(A1,3)Date in Excel 5

Subtracting Months from a Date To subtract months from a date, simply use a negative number in the second argument of the EDATE formula.Date in Excel 6 For example, to get a date 6 months in the past from 10-Jan-22 (in cell A1), use the following formula:

Example: =EDATE(A1,-6)

This will give us the date 10-Jul-21 in cell B1, which is exactly 6 months before the original date.

4
52 Views
How to quickly and easily convert an Excel file to PDFPrevHow to quickly and easily convert an Excel file to PDFApril 28, 2023
How to Add Years to a Date in ExcelApril 28, 2023How to Add Years to a Date in ExcelNext

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $11.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.