Hello fellow T-tards,
I am looking to set up a visit window calculator in an Excel document, where visits will be scheduled either every 4 weeks (+/- 5 days) or every 6 weeks (+/- 5 days) relative to the initial visit.
For example, say I met someone today, 11Aug and they are on the 4 week plan. Visit 2 would need to be within 23 to 33 days from that date (3Sep to 13Sep), V3 would need to be between 51 to 61 days (1Oct to 11Oct), V4 would need to be between 79 and 89 days (29Oct to 8Nov), etc. I would like the function to calculate these ranges for me based on my single input at Visit 1.
V1 would be entered in cell E7, with the subsequent visit windows occurring in every cell in row 6 from G onwards (if that matters for an explanation).
Anyone know how to go about doing this?