1 2 Previous Next 27 Replies Latest reply on Oct 24, 2017 8:45 AM by Sherzodbek Ibragimov

    dates

    David Gabra

      Please can you let me know how to do this

       

      I would like to know how many days late vacations payments are made.

       

       

      I have the following

       

      I just  need a formula that states that were the is vacation pay - take the termination date and minus this from the  last day of the month (in the month column)

       

       

       

            

      EmpMonthOrderTermination Vacation Pay Calc Field
      aaJan 1February 1, 2017
      aaFeb2February 1, 2017
      aaMarch3February 1, 2017
      aaApril4February 1, 2017
      aaMay5February 1, 2017400Vacation paid late  (ie. May 30th - Feb 1st)
      aaJun 6February 1, 2017
      bbJuly1June 1, 2017
      bbAugust2June 1, 2017300Vacation paid late  (ie. August minus  -June 1st)
      bbSeptember3June 1, 2017

       

      thanks

        1 2 Previous Next