I am working on a lead generation tracking spreadsheet in Google Sheets with the hopes of having a follow-up date auto-populate. There are different amounts of time when we want to follow up with contacts (i.e. 1 week, 2 weeks, 4 months, 6 months) and I have created a drop-down via the data validation tool in Google Sheets for our sales guy to choose from.
I also have a place where he will enter the date of contact. I am really looking for a formula that takes the date of contact and configures when he should follow up with that lead depending on his drop-down selection. Below is a screenshot of the top of the spreadsheet.