Forum Discussion
Assigning different formulas to unique IDs
Hi there everyone! I have a simple table of 8 areas of different sizes where 3 unique teams will work on. The initial start date is manually inputted, the end date is then calculated by taking the st...
Talap1730 I would insert one extra column where you put the initial dates for each team. Then you can calculate the start date for each row with a formula using MAX and MAXIFS for all.
See if the attached file does what you require.