Calculate number of remaining payrolls

  • Profile Image
    Asked on November 18, 2021 at 09:10 PM

    I have two dates.



    Is there a form calculation that will allow me to determine the number of remaining payrolls between those dates if we have 26 payrolls annually?

    My Excel formula is this:

    =DATEDIF(N9,N10, "d")/14

    N9 would be 11/15/21

    N10 would be 12/31/21

    Is there a way to get this calculation into my form?

  • Profile Image
    Answered on November 19, 2021 at 04:28 AM


    Thank you for contacting us, please see the following tutorial on date and time calculations:

    Please let us know if you require any further assistance.

    Have an amazing day.