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!
