Excel Formula Assistance

Copper Contributor

Good morning,


I am required to complete a reauthorization for clients one year after the date they initially enter our program and then every 6 months thereafter. Currently, I have a list of clients with their intake dates into the program in column I. In the next column, J, I have the date that the initial reauthorization is due (one year after the date in column I). I then have a column, K, where I am trying to figure out how to have a rolling date, 18 months from the intake date (date in column I), and then 24 months, 30 months, 36 months, etc. Is there a formula I can use in column K that will automatically calculate these due dates based on the date in column I?


Thank you!

1 Reply


You can use the EDATE() function:




The second option is the number of months. In my example, I2 contains the starting date.