Due dates formula

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I need to set 4 due dates that will be based on number of days (End Date - Start date), divided by 5 which will make 5 periods of same length. And a due date is the first day of each period except the first one. 
Photo of Inna

Inna

  • 82 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
Try these five formulas:

==========================================================
[Due Date 1] formula:
var Number NumDays = ToDays([End Date] - [Start Date]);
var Number IntDays = Int($NumDays / 5);
var Number RemDays = Rem($NumDays, 5);
[Start Date] + Days(If($RemDays  = 0, 1 * $IntDays,  1 * ($IntDays + 1)))
==========================================================
[Due Date 2] formula:
var Number NumDays = ToDays([End Date] - [Start Date]);
var Number IntDays = Int($NumDays / 5);
var Number RemDays = Rem($NumDays, 5);
[Start Date] + Days(If($RemDays  = 0, 2 * $IntDays,  2 * ($IntDays + 1)))
==========================================================
[Due Date 3] formula:
var Number NumDays = ToDays([End Date] - [Start Date]);
var Number IntDays = Int($NumDays / 5);
var Number RemDays = Rem($NumDays, 5);
[Start Date] + Days(If($RemDays  = 0, 3 * $IntDays,  3 * ($IntDays + 1)))
==========================================================
[Due Date 4] formula:
var Number NumDays = ToDays([End Date] - [Start Date]);
var Number IntDays = Int($NumDays / 5);
var Number RemDays = Rem($NumDays, 5);
[Start Date] + Days(If($RemDays  = 0, 4 * $IntDays,  4 * ($IntDays + 1)))
==========================================================
[Due Date 5] formula:
[End Date]
Photo of Inna

Inna

  • 82 Points 75 badge 2x thumb
Thank you sooo much!! I'd been working on it for ages and still couldn't figure out how to do it. Thanks again!