Forum Discussion
Sequence Formula for Deadline Calculations
Good afternoon. I have been tasked with calculating the deadline dates for start dates on rolling courses. I am currently working to develop the best system. Currently, multi people have been manual...
I'm not sure I understand all that but maybe:
=let(maxD, MAXIFS(G:G,H:H,H27), maxD+4+7*(maxD=G27))basically this will find the max date from column G that has the same class name as "this" row and then add 4 to that and then add another 7 if "this" row is that max date
