Hi, I need help to work out the frequency of visits for customers based on their sign up date. The frequencies we offer are 1, 4, 8, 12, 13, 26 and 52. What this means is that if a customer sign up today (03/07/2018) and frequency of 1 was chosen we would next undertake a visit on 03/07/2019. If frequency 4 was chosen it would be every 3 months (03/10/2018), frequency 8 would be every 6 weeks (14/08/2018), frequency 12 is every month, frequency 26 is every two weeks and 52 is every week.
Hope someone can help
Solved by F. J. in 15 mins