Please forgive my ignorance before I ask my question. On my excel document, in one cell I have the date a patient comes in. In another cell, I have the patients age. The issue I'm having, in the next cell, I need a formula to add the current date of appointment, if the patient is a certain age, then calculate the next date of the appointment.
Example:
Date AGE Next Visit Date
02/02/2018 1 (0-1 yrs old add 3 months to first cell to = next visit) ?
2 (2-4 yrs old add 4 months to first cell to = next visit) ?
5 (5-7 yrs old add 5 months to first cell to = next visit) ?
I hope someone can help me or even understand my madness is explaining this.
Thank you.
Bookmarks