加上迄今为止的年份,例如,加上3年,请使用公式: = DATE(YEAR(A2)+ 3,MONTH(A2),DAY(A2)) 要在日期中添加月份,例如添加 2 个月,请使用以下公式: = EDATE(A2,2) = A2 + 60 提示: 使用EDATE 函数添加月份时,结果将以序列号的一般格式显示。您需要将结果格式化为日期。 使用Kutools for Excel 添加迄今...
Add months/years/days to date with formula If you want to add months, years or days to a date or dates, you can apply one of below formulas as you need. Add years to date, for instance, add 3 years, please use formula: =DATE(YEAR(A2)+3,MONTH(A2),DAY(A2)) To add months to ...
EDATE is a built-in function in Excel. It falls under the Date andTime functions category in Excel. So, it is used to get the same date of the month ‘Y’ months in the future or the past. So basically, it returns the serial number of the date, which is the specified number of ...
要向日期分别添加或减去年/月/日,您只需选择以下公式之一: 加一年=DATE(YEAR(Date)+1,MONTH(Date),DAY(Date)) 减一年=DATE(YEAR(Date)-1,MONTH(Date),DAY(Date)) 加两个月=EDATE((date),2) 减去两个月=EDATE((date),-2) 加三天=(Date)+3 减去三天=(Date)-3 同时添加或减去年,月,日 如果要...
SelectColumns > Date > Month. Enter3in theStep valuebox. ClickOK. The Fill Series Function will autofill the results. Read More:How to Add 6 Months to a Date in Excel Method 4 – Using VBA Code We can also applythe DateADD functionto update the date usingVBA code. Let’s add 3 mon...
YEAR(C7)+$C$4: This argument in the DATE function shows the number of years for the date and it returns the value by adding the value of C4 cell (5) as 2023. =DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7)): This whole function finally shows the result as 1/1/2023. Use the Fill ...
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. ...
In this case, you can apply the DATE function to solve the problem. = DATE(YEAR(date) + number of years, MONTH(date) + number of months, DAY(date) + number of days) 1. Select the blank cell you will place the calculating result, type the formula =DATE(YEAR(A2)+3,MONTH(A2)...
function, you specify the date (source date) to which you want to add months and the number of months to add. Excel then calculates the resulting date and displays it in your selected cell. To subtract months from a date, enter a negative month number. For example, to remove 3 months ...
=DATE(YEAR(A2),MONTH(A2),+2,DAY(A2)) Add or Subtract Months with the Excel EDATE Function EDATE formula will return a date that’s specified number of months before or after the start date. This formula contains two arguments. The Start Date value (the date to which you want to add...