fulanito_uk
New Member
- Joined
- Nov 30, 2015
- Messages
- 42
- Office Version
- 2010
- Platform
- Windows
Hi, I got some help from here a few days ago, now I need help with another formula.
Basically what I need is day count in column J:
IF column I is blank: Networkdays H and $B$1
IF column I has a date: Networkdays H and I
For instance Row 3 would be =networkdays(h3,B1)
Row 4 would be=networkdays(h4,I4)
Thanks for your help!
Basically what I need is day count in column J:
IF column I is blank: Networkdays H and $B$1
IF column I has a date: Networkdays H and I
For instance Row 3 would be =networkdays(h3,B1)
Row 4 would be=networkdays(h4,I4)
Thanks for your help!