EDATE function in Excel

Excel Date and Time Functions return a dynamic date or time in a cell.

How to get same date next month or previous month in Excel

To get the same date next month from a given date, you can use the EDATE function. Formula =EDATE(date,1) Explanation In the example shown, the formula in cell B5 is: =EDATE(B5,1) How this formula works EDATE can get the “same date” in the future or past, based on the number of months supplied. When 1… read more »

How to get same date next year or previous year in Excel

To get the same date next year from a given date, you can use the EDATE function. Formula =EDATE(date,12) Explanation In the example shown, the formula in cell B5 is: =EDATE(B5,12) EDATE can get the “same date” in the future or past, based on the number of months supplied. When 12 is given for months,… read more »

How to calculate next anniversary date or birthday in Excel

To calculate the next anniversary date, you can use a formula based on the EDATE and DATEDIF functions. Case Study: Assume fixing anniversary date as June 1, 2017 in all examples. Formula =EDATE(date,(DATEDIF(date,as_of,”y”)+1)*12) Explanation In the example shown, the formula in D5 is:  =EDATE(B5,(DATEDIF(B5,C5,”y”)+1)*12) This formula will work to calculate next upcoming birthday as well. How this… read more »

How to calculate future date say 6 months ahead in Excel

— Next business day 6 months in future To get a date 6 months in the future, on the next work day, you can use a formula based on the WORKDAY function, with help from EDATE. Formula =WORKDAY(EDATE(date,6)-1,1,holidays) Explanation In the example shown, the formula in C6 is =WORKDAY(EDATE(B6,6)-1,1,B9:B11) How this formula works Working from the… read more »

Calculate retirement date in Excel

If you need to calculate retirement date in Excel, then this tutorials is for you. To calculate a retirement date based on a birth date, you can use the EDATE function. See example below; Formula =EDATE(A1,12*60) Explanation In the example shown, the formula in D6 is: =EDATE(C6,12*60) How this formula works The EDATE function is fully automatic, and will… read more »

Calculate expiration date in Excel

If you need to calculate an expiration in the future, you can use a variety of formulas. See example below; Formula =A1+30 // 30 days Explanation In the example shown, the formulas used in column D are: =B5+30 // 30 days =B5+90 // 90 days =EOMONTH(B7,0) // end of month =EDATE(B8,1) // next month =EOMONTH(B7,0)+1… read more »

Add days to date in Excel

It you need to add days to date in Excel then this tutorials is for you. See example below: To add a given number of years to a date, you can use the EDATE function. Formula =date+days Explanation In the example shown, the formula in D5 is: =B5+C5 How this formula works Dates in Excel are… read more »

Add months to date in Excel

It you need to add months to date in Excel then this tutorials is for you. See example below: To add a given number of years to a date, you can use the EDATE function. Formula =EDATE(date,months) Explanation In the example shown, the formula in D5 is: =EDATE(B5,C5) How this formula works The EDATE function is… read more »

Add years to date in Excel

If you need to add years to date in Excel then this tutorials is for you. See the example below . To add a given number of years to a date, you can use a formula based on the DATE function, with help from the YEAR, MONTH, and DAY functions. Formula =DATE(YEAR(date)+years,MONTH(date),DAY(date)) Note: if you need… read more »

Sidebar