AnsweredAssumed Answered

Calculating 20th of the Month deadlines in the future

Question asked by ErikaMarmolejo on Jul 22, 2013
Latest reply on Jul 22, 2013 by LaRetta_1

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.

Outcomes