I need to create a spreadsheet that will show the next month a patient needs to be seen. I have columns for the patient, date last seen, the next 30 day or 120 follow-up, however I am hoping to list the upcoming months in columns and have a formula that populates the next 30 or 120 day visit in the appropriate month column. Possible?
Of course, it is possible. But this is a bad idea - to use the spreadsheets as a store data that deployed in time. I am strongly recommend that you use database for this task.