I have what should be an easy one, but just cannot get the solution I am looking for. I have a file where I have many employees, each employee works on certain days and each work date equals a certain pay period end date (in my case a Sunday) I want to identify for each employee when a new pay period end date occurs and then flags the last work date in which this occurs. From there I can perform some further calculations on each occurrence. Attached is an excel file representing what I am trying to do.
Thx for the help
Book1.xlsx (10.4 KB)