I have a monthly table that repeats the past classification for the YTD total days calculation: Employee Date Schedule YTD Days X 1-Jan-16 3WX1W 31 X 1-Feb-16 3WX1W 60 X 1-Mar-16 3WX1W 91 X 1-Apr-16 3WX1W 121 X 1-May-16 3WX1W 152 X 1-Jun-16 3WX1W 182 X 1-Jul-16 3WX1W 182 X 1-Jul-16 4WX4W 31 X 1-Aug-16 3WX1W 182 X 1-Aug-16 4WX4W 61 X 1-Sep-16 3WX1W 182 X 1-Sep-16 4WX4W 92 X 1-Oct-16 3WX1W 182 X 1-Oct-16 4WX2W 31 X 1-Oct-16 4WX4W 92 X 1-Nov-16 3WX1W 182 X 1-Nov-16 4WX2W 61 X 1-Nov-16 4WX4W 92 X 1-Dec-16 3WX1W 182 X 1-Dec-16 4WX2W 91 X 1-Dec-16 4WX4W 92   So from Jan to Jun the employee had the 3WX1W classification, from Jul to Sep the employee was 4WX4W and after Oct the employee is 4WX2W. I to obtain this table:   Employee Date Schedule X 1-Jan-16 3WX1W X 1-Feb-16 3WX1W X 1-Mar-16 3WX1W X 1-Apr-16 3WX1W X 1-May-16 3WX1W X 1-Jun-16 3WX1W X 1-Jul-16 4WX4W X 1-Aug-16 4WX4W X 1-Sep-16 4WX4W X 1-Oct-16 4WX2W X 1-Nov-16 4WX2W X 1-Dec-16 4WX2W   Sorry for making such a basic question, but i am just starting... Thanks a lot in advance! ... View more