3 Replies Latest reply on Jul 22, 2013 7:34 PM by LaRetta_1

    Calculating 20th of the Month deadlines in the future

    ErikaMarmolejo

      Title

      Calculating 20th of the Month deadlines in the future

      Post

           I have an expiration date field and then I have two target submission date fields.  The target 60-day submission date field should calculate 60-days from the expiration date and it should calculate the 20th of that target month and if that 20th falls on a weekend it should calculate the Friday prior.  The other fieldar will target 90-day submission date field should calculate 90-days from the expiration date and it should calculate the 20th of that target month and if that 20th falls on a weekend it should calculate the Friday prior.

           Not sure what function to start with to calculate the dates.

           Thanks.