Feb 12 2020 10:00 AM - edited Feb 12 2020 10:14 AM
Hello,
In the attached document, I need help with formulas.
Thank you!
Feb 13 2020 02:24 AM
Like in the attached file? I've assumed that "first date" = earliest date and "last date" = latest date.
But, I must admit that I don't really see the logic of such formulae. I trust that you do. By the way, what if there are more persons "in progress" at the same time? What would you expect in the yellow cell?
Feb 13 2020 07:44 AM
@Riny_van_Eekelen Thank you! I am using the spreadsheet as a secondary tab that feeds back into a summary tab in the workbook.
In theory there should only be one person in progress as they need to complete the project steps in sequential order. If there comes a time that more than one is in progress at the same time, I'll look at changing my formula.