3 Replies Latest reply on Feb 1, 2019 12:35 PM by Ken Flerlage

    Count Employee missing Date Entries

    muhammad usman

      I have an employee  data which have Employee Name , Date (For which he worked)

      I wanted to show the missing dates for which he did not work

       

      For example if Today is 21st Jan 2019

      and employee enter his data till 19th Jan 2019 then the expected output would be

      Employee Name | Missing Dates

      Mike                        20-1-2019

      Mike                        21-1-2019

       

      I am attaching my the workbook which i am using with Data

       

      Please Help

      Thanks