Add years to date, for instance, add 3 years, please use formula: =DATE(YEAR(A2)+3,MONTH(A2),DAY(A2)) To add months to a date, for instance, to add 2 months, use the following formula: =EDATE(A2,2) =A2+60 Tip: When you use the EDATE function to add months, the result wil...
When using the EDATE function, you can also specify the start date and the number of month to add / subtract directly in the formula. Dates should be entered by using the DATE function or as results of other formulas. For example: Toaddmonths in Excel: =EDATE(DATE(2015,5,7), 10) Th...
How this formula work Here takes an instance to explain how the formula works in Excel. Adding number of years which is placed in cell C3 to the date in cell B3, please use below formula:=DATE(YEAR(B3)+C3,MONTH(B3),DAY(B3))
Below is the formula that will do this: =EDATE(A2, B2*12) The result in C2 isMay 31, 2022, which is 1 year after May 31, 2021. As you can see, the parameter months is 12 (1 year * 12 months). Also, since we are multiplying the month’s value with 12, you can also use ...
Here’s the formula for subtraction: =C5-D5 Method 3 – Add and Subtract Months to Date in Excel You may use the DATE, YEAR, MONTH, and DAY functions to add or subtract a certain number of full months from a date, as seen below. =DATE(YEAR(date), MONTH(date) + X months, DAY...
The EDATE function correctly returns the last day of month if the start day is 31. For example, the formula below returns 30-Apr-2023, which is a date 3 months after 31-Jan-2023: =EDATE("31-Jan-2023", 3) It also maintains the last day of February in leap years. For instance, th...
Example 2 – Using the MONTH and the Date Functions to Add the Month to a Date in Excel Steps: Enter the formula in E5. =DATE(YEAR(C5),MONTH(C5)+D5,DAY(C5)) Formula Breakdown The DATE function takes three arguments. Here, you only need to increase the month: in the second argum...
A formula using the EDATE function has two mandatory criteria—a date and the number of months to add or subtract. For example,=EDATE(“01/01/2022”,1)would return the date01/02/2022(DD/MM/YYYY) by adding one month to the start date. ...
Use Month & Year Functions for Month-Year Formula You can also write a formula by combining YEAR and MONTH functions. YEAR extracts the year from a date. For example, if you specify a date like “5/8/2024” into it, it will return “2024”. And, the MONTH returns the month number ...
Hello, I saw in format Cells you can select date / 4/3/12 1:30PM and then go agan in the cell to personalize, but how it is working to have for instance...