I have a list of 35 people who need to take a test periodically, some of them every 2 month, some every 3 month, some every 6 months, it depends, I want to create a calendar, where in the column E is January, in column F is February, in column G is March, etc.
In the row 2 are the dates of the first person: E2 = date 1(February 2017), F2 = date 2(April 2017), G2 = date 3(June 2017), etc.
I want to put those dates in the respective column for example date 2 should be in the column F which is February, date 3 should be in column H which is April and so on...
if it is possible I do not want to use vba and/or macros.
Thank you for your time
FYI: I upload the excel workbook I am working on, the working sheet is sheet 2
Bookmarks