Based on the comment in your file, Friday is your weekend?
In H2 (not an array formula).
=MAX(0,$C3/$D3*NETWORKDAYS.INTL(MAX($E$3,G$2+1),MIN($F$3,H$2),16))
Then drag it right.
Based on the comment in your file, Friday is your weekend?
In H2 (not an array formula).
=MAX(0,$C3/$D3*NETWORKDAYS.INTL(MAX($E$3,G$2+1),MIN($F$3,H$2),16))
Then drag it right.
Mr. Jason,
Thanks for your reply.
It is very good logic by using Max and Min functions. Till now I am using in other models very lengthy process. Now it is good and it is also useful for single activity logic.
But can I get the formula without weekends in that same which I send. Because this I can use as array formula in other works.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks