L33
Board Regular
- Joined
- Jul 2, 2008
- Messages
- 108
Hi,
I found this handy formula some months ago on these messageboards:
=countif(Sheet1!B:B,">=01/03/08")-countif(Sheet1!B:B,">31/03/08")
It counts number of dates in a given list of dates within the specified period.
But I now want to replace the underlined sections with cell references - but whatever I try, Excel won't let me do that.
Basically, I want put dates in to two cells, use Networkdays to get working days, then deduct the number of days in a pre-defined list between those two dates aswell.
I know there's a holidays parameter on the Networkdays function, but I need to display this to users in a step by step fashion.
Any help much appreciated.
I found this handy formula some months ago on these messageboards:
=countif(Sheet1!B:B,">=01/03/08")-countif(Sheet1!B:B,">31/03/08")
It counts number of dates in a given list of dates within the specified period.
But I now want to replace the underlined sections with cell references - but whatever I try, Excel won't let me do that.
Basically, I want put dates in to two cells, use Networkdays to get working days, then deduct the number of days in a pre-defined list between those two dates aswell.
I know there's a holidays parameter on the Networkdays function, but I need to display this to users in a step by step fashion.
Any help much appreciated.