As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Adding Months to a Date in Excel: A Step-by-Step Tutorial

In Excel, various methods can be employed to add months to a date. Utilizing either the EDATE function, the DATE function, or a combination of both can achieve this. Below is a detailed guide on how to execute each method.

Method 1: Using the EDATE Function

  1. Insert the Start Date in a Cell: Input 1/1/2020 as the start date in cell A1 for the purpose of this example.
  2. Enter the Number of Months to Add: Input the desired number of months (e.g., 3 months) into cell A2.
  3. Use the EDATE Function: In cell A3, enter the formula: =EDATE(A1, A2)
  4. Observe the Result: The function will display the new date, such as 4/1/2020 for this instance.

Method 2: Using the DATE Function

  1. Input the Start Date in a Cell: Enter 1/1/2020 in cell A1.
  2. Determine the Year, Month, and Day: For example, for adding 3 months, specify the year, month, and day (2020, 4, 1) for the new date.
  3. Utilize the DATE Function: In cell A2, input the formula: =DATE(2020, 4, 1)
  4. Check the Result: The function will reveal the new date, e.g., 4/1/2020.

Method 3: Using a Combination of EDATE and DATE Functions

  1. Enter the Start Date in a Cell: For instance, use 1/31/2020 in cell A1.
  2. Use the EDATE Function for the New Date: In cell A2, input: =EDATE(A1, 1) to obtain the new date, such as 2/29/2020.
  3. Utilize the DATE Function for Adjusting Days: In cell A3, enter: =DATE(YEAR(A2), MONTH(A2)+1, DAY(A2)) to adjust the date to 3/31/2020.
  4. View the Result: The function will showcase the new date, which in this case is 3/31/2020.