I haven't been able to figure out how to combine these logic & date formulas in 1 cell.
- My parameters would be:
- A2 will always have a manually entered date in it
- B2 could have one of three manually entered data in it
- A date (mm/dd/yy)
- BLANK (as in nothing because the date is unknown)
- "N/A" (as in a date is not applicable for that entry)
- The results I need in C2 is one of three options
- The result of the formula =NETWORK(A2,B2)
- "UNKNOWN" because there should be a date in B2 but there isn't to calculate NETWORKDAYS
- "N/A" because there isn't a need to calculate NETWORK days for that data set.
- I know some base formulas that could be used if I had only 2 variables
- IF=(NETWORKDAYS(A2,B2)<0,"UNKNOWN",NETWORKDAYS(A2,B2))
- IF=(B2="N/A","N/A",NETWORKDAYS(A2,B2))