Hello!
I am trying to do a scheduling formula wherein I have a block of cells which will become my start date. If I didn't have a constraint, the rows above these dates will simply be date+1. However, I can only schedule a maximum of 4 things on a given date. So, I need a formula that will do this:
Row 3, Column A: If (7/12/16 + 1) has not occurred 4x, then 7/13/16, else 7/14/16. However, if 7/14/16 has also occurred 4x, make it 7/15/16, etc....
Column A B C....
Row 1 7/12/2016 7/13/2016 7/15/2016 7/11/2016 7/20/2016 7/13/2016 7/14/2016 7/13/2016 7/16/2016
Row 2 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016
This means that on Row 3, Colum A, the "next date" assigned would be:
Row 3 7/13/2016 7/14/16 7/16/2016 7/12/2016 7/21/2016 7/14/2016 7/15/2016 7/14/2016 7/17/2016
Row 4 7/12/2016 7/12/2016 7/12/2016 7/13/2016 7/13/2016 7/13/2016 7/14/2016 7/15/2016 7/15/2016
VBA or non-VBA solution would work!
Thanks!
I am trying to do a scheduling formula wherein I have a block of cells which will become my start date. If I didn't have a constraint, the rows above these dates will simply be date+1. However, I can only schedule a maximum of 4 things on a given date. So, I need a formula that will do this:
Row 3, Column A: If (7/12/16 + 1) has not occurred 4x, then 7/13/16, else 7/14/16. However, if 7/14/16 has also occurred 4x, make it 7/15/16, etc....
Column A B C....
Row 1 7/12/2016 7/13/2016 7/15/2016 7/11/2016 7/20/2016 7/13/2016 7/14/2016 7/13/2016 7/16/2016
Row 2 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016 7/11/2016
This means that on Row 3, Colum A, the "next date" assigned would be:
Row 3 7/13/2016 7/14/16 7/16/2016 7/12/2016 7/21/2016 7/14/2016 7/15/2016 7/14/2016 7/17/2016
Row 4 7/12/2016 7/12/2016 7/12/2016 7/13/2016 7/13/2016 7/13/2016 7/14/2016 7/15/2016 7/15/2016
VBA or non-VBA solution would work!
Thanks!