Hi,
I am new to formulas. If I have the initial visit date in one column, I'm wondering if there is a way to have actual dates inserted in preceding columns based on the initial visit date: 1 column showing the next possible visit date +X week or days date max and then in another column the -X week or days date min. Is that possible?
Ex:
Initial date is 1/1/2025
Visit 2 would be 3 months out from 1/1/2025 (with + 14 days acceptable or - 14 days acceptable)
Can that be automated so we don't have to look at a calendar to figure out what the next visit window can be?
Thank you!
Emi
