saurabhbiswas123
Board Regular
- Joined
- Jul 16, 2008
- Messages
- 71
Dear All,
I want to capture the Actual Working days between Project Start & Finish Date(excluding SUNDAY only as weekly off day).
In cell A1 I have got the Project Start Date(in MMDDYYYY format) and in cell B1 I have got the Project finish date(in MMDDYYYY format).
In cell C1 I am using the following formula:-
=Networkdays(a1,b1)
But it is giving me misleading no of days since it deducts both Saturday & Sunday.
I want a formula in cell c1 which can give the actual no of days between start & finish date by deducting Sunday only.
Pls help.
Thanks
Saurabh Biswas
I want to capture the Actual Working days between Project Start & Finish Date(excluding SUNDAY only as weekly off day).
In cell A1 I have got the Project Start Date(in MMDDYYYY format) and in cell B1 I have got the Project finish date(in MMDDYYYY format).
In cell C1 I am using the following formula:-
=Networkdays(a1,b1)
But it is giving me misleading no of days since it deducts both Saturday & Sunday.
I want a formula in cell c1 which can give the actual no of days between start & finish date by deducting Sunday only.
Pls help.
Thanks
Saurabh Biswas