Calculate number of remaining payrolls

  • troostcemeteries
    Asked on November 18, 2021 at 9:10 PM

    I have two dates.

    11/15/21

    12/31/21

    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?

  • Collin_S
    Replied on November 19, 2021 at 4:28 AM

    Hi,

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

    https://www.jotform.com/help/443-mastering-date-and-time-calculation/

    Please let us know if you require any further assistance.

    Have an amazing day.