Has anyone successfully used NETWORKDAYS with arrays?
5/10/2005 5/12/2005 3 #VALUE!
4/28/2005 6/10/2005 32 #VALUE! 4/25/2005 6/15/2005 38 #VALUE! 4/8/2005 8/8/2005 87 #VALUE! The third column uses NETWOKDAYS(Q3,P3). The fourth column uses the ranges (either as named ranges or Q3:Q6, P3:P6) and the array command (Ctrl+Shift+Enter). I cannot get any permutation of the fourth column to work and I suspect NETWORKDAYS does not work with arrays. Please, someone tell me I'm wrong! |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com