Hello,
I would like to ask for your assistance in creating formulas under First Day Colum and Last Day Column.
I would like to ask for your assistance in creating formulas under First Day Colum and Last Day Column.
- There are duplicate entries under Programs column
- The First day column shall provide result of the first activity (End date minus Start date)
- The Last day column shall provide results of the last activity (End date minus Start date)
- Activities in between the first day and last day (same activity name) shall have a blank result
- Activity with single entry shall has results for both First day and Last day (End date minus Start date)
Programs | Start | End | First Day | Last Day |
Activity 1 | 10/1/20 | 10/2/20 | 1 | |
Activity 2 | 10/1/20 | 10/2/20 | 1 | 1 |
Activity 3 | 10/1/20 | 10/4/20 | 3 | |
Activity 1 | 10/1/20 | 10/3/20 | ||
Activity 1 | 10/1/20 | 10/4/20 | 3 | |
Activity 3 | 10/1/20 | 10/5/20 | 4 |