Hi Jess, I would like to ask you a question where on this excel sheet, i have the start date of our clients and every 6 months we need to make a visit, Is there a Formula where we can put it one of the columns as once I put the start date, in the next column it automatically puts in the number of visits needed, for exame 01/01/13, therefore the visits will be 07/01/13, and the next visit is 01/01/14, so the number of visits needed is 1 and the date required is 07/01/13 and the next one scheduled is 01/01/14, here is the document
I'm Lindie, and I’m a moderator for this topic. I sent your requested professional a message to follow up with you here, when they are back online.
If I can help further, please let me know. Thank you for your continued patience.
Thank you for your reps Jess, yes for your example, Start date is 7/10/2014, and the present date is 01/30/15, then I would like a column, that will show the Number of Visits which is 1 , and the other column shows me the date of 01/10/2015 as the visit or visits date, and the other column of the next SUP visit which is 7/10/2015,
Upto 6 say for example or can we go to any number, for example the client was on 07/10/2011 then today we would have needed to complete visits on the 01/10/2012, 07/10/2012, 01/10/2013, 07/10/2013 so 4 SUP visits would have needed to be completed, and the fifth visit would be on the 01/10/2014, May be 6 would be the maximum,
Yes that's perfectly fine
Is there a way where the SUP visits column gets automatically gets filled
Hello Jess, Thank you very much for your answer, Is there a way where the SUP visits column gets automatically filled
The conditions are
If it more the 6 months and less than one year, from the start date to present date of today it is = 1, and if it is more than 1 year and less than 18 months it is equal to 2,
Yes Jess, when the date has passed that is exactly what i was saying, 10/5/2013 then SUP Visit =4
Thank you very much Jess for the answer, and the time, I will take note of the formula that you had entered on a side one can you tell me what is the "" on the formula line Thank you once again,
Thank you Very much Jess, for your time and answer and for the detailed explainations on the formula, thank you once again. I understand about the time zones and I am always patient.