searchingforhelp
Board Regular
- Joined
- Nov 11, 2020
- Messages
- 67
- Office Version
- 365
- Platform
- Windows
I am having trouble combining formulas and deciphering which formula is best for what is needed. I am currently using the NETWORKDAYS formula, but I cannot connect it with what I am trying to accomplish due to my skill sets.
What I need assistance in is as follows:
1. the formula needs to calculate business days only, excluding weekends.
2. I would need to calculate the days from when the assignment was originally assigned (Column A) to the date when assignment was completed (Column C). However, if there is a reassignment date (column B), have the formula automatically adjust to calculate the reassignment date (Column B) to when the assignment was completed (column C).
3. Lastly, if the reassignment date (Column B) exceeds the assignment completion date, automatically calculate original assigned date (Column A) from when the assignment was completed.
This is where I am stuck. Combining 1,2 and 3 into one formula so I can drag down as more data is entered on the sheet.
Thanking you in advance for any help you can provide.
What I need assistance in is as follows:
1. the formula needs to calculate business days only, excluding weekends.
2. I would need to calculate the days from when the assignment was originally assigned (Column A) to the date when assignment was completed (Column C). However, if there is a reassignment date (column B), have the formula automatically adjust to calculate the reassignment date (Column B) to when the assignment was completed (column C).
3. Lastly, if the reassignment date (Column B) exceeds the assignment completion date, automatically calculate original assigned date (Column A) from when the assignment was completed.
This is where I am stuck. Combining 1,2 and 3 into one formula so I can drag down as more data is entered on the sheet.
Thanking you in advance for any help you can provide.
Example.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date when Originally assigned | Date when assignment was reassigned | Date when assignment was completed | Number of Days | ||
2 | 3/10/2021 | 3/12/2021 | 3 | |||
3 | 3/10/2021 | 3/11/2021 | 3/18/2021 | 6 | ||
4 | 3/10/2021 | 3/15/2020 | 3/11/2021 | 2 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2,D4 | D2 | =NETWORKDAYS(A2,C2) |
D3 | D3 | =NETWORKDAYS(B3,C3) |