bloodmilksky
Board Regular
- Joined
- Feb 3, 2016
- Messages
- 202
Hi guys,
I was just wondering if anyone could help me with this query.
I have a holiday calendar and I am totalling the days taken as holiday using NETWORKDAYS
B1 C1 D3
02/01/2016 + 05/01/2016 = 2 (Networkdays)
But what I was wondering is if there is a way of incorporating an IF statement into this sum So if AM/PM followed the date it would only count as 0.5 but if Full followed the date it would count as 1.
B1 C1
02/01/2016AM + 02/01/2016AM = 0.5 (Networkdays)
B1 C1
02/01/2016FULL + 02/01/2016FULL = 1 (Networkdays)
any help would be greatly appreciated
Many thanks
jamie
I was just wondering if anyone could help me with this query.
I have a holiday calendar and I am totalling the days taken as holiday using NETWORKDAYS
B1 C1 D3
02/01/2016 + 05/01/2016 = 2 (Networkdays)
But what I was wondering is if there is a way of incorporating an IF statement into this sum So if AM/PM followed the date it would only count as 0.5 but if Full followed the date it would count as 1.
B1 C1
02/01/2016AM + 02/01/2016AM = 0.5 (Networkdays)
B1 C1
02/01/2016FULL + 02/01/2016FULL = 1 (Networkdays)
any help would be greatly appreciated
Many thanks
jamie