Need formula

I have a column called VISITS, where numbers are from 3,4,6,12.

 

Now depend on the number I should have these numbers equally distributed in months.

 

For Example, VISITS=4, if I devide 12 months by 4, answer is 3. Now tis number 3 should be splitted in 12 months, i.e. my 1st visit will be in month of JAN 2nd will be in month APR and so on

 

Below is table, this is how I am expecting a formula to do this automatically based on my VISITS:

Visits Description Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
4 Visit will be after every 3 months 1     2     3     4    
6 Visit will be after every 2 months 1   2   3   4   5   6  

 

By: Ram

Leave a Reply

Your email address will not be published. Required fields are marked *