Forum Discussion

T-Rex929's avatar
T-Rex929
Copper Contributor
May 09, 2024

Excel Formula Assistance

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!

Excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    May 09, 2024

    T-Rex929 

    You can use the EDATE() function:

    e.g.:

     

    =EDATE($I2,36)

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

Share

Resources