fulanito_uk
New Member
- Joined
- Nov 30, 2015
- Messages
- 42
- Office Version
- 2010
- Platform
- Windows
Good morning,
I have a question about a sheet I am doing I will give some context.
I have 3 possible status options OPEN, MAYBE, CLOSED,
If the status is OPEN or MAYBE i need the NETWORKDAYS to calculate from DATE 1 (A) and DATE 3 (D)
If the status is CLOSED I need the NETWORKDAYS to calculate from DATE 2 (B) and DATE 3 (D).
If you need any more information for my side please let me know and Thank you very much for your help.
I have a question about a sheet I am doing I will give some context.
I have 3 possible status options OPEN, MAYBE, CLOSED,
If the status is OPEN or MAYBE i need the NETWORKDAYS to calculate from DATE 1 (A) and DATE 3 (D)
If the status is CLOSED I need the NETWORKDAYS to calculate from DATE 2 (B) and DATE 3 (D).
If you need any more information for my side please let me know and Thank you very much for your help.