Hi,
Please help on the enclosed Array formula which is F9 function.
I need the counting of days between two dates range with out weekend to match the total quantity.
Formula to be corrected at H3 is
=SUM($C3/$D3*(TRANSPOSE(ROW(INDIRECT(G$2+1&":"&H$2)))<=$F3)*(TRANSPOSE(ROW(INDIRECT(G$2+1&":"&H$2)))>=$E3))
Thanks.
Last edited by roven.aravind; 07-14-2018 at 08:56 AM. Reason: Subject change
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.
Why not use the non array in other works?
If you have to change the array formula to exclude friday then you can just as easily change it to Min Max or similar.
I assume that the formulas in question are the ones in this thread?
https://www.excelforum.com/excel-for...hing-data.html
I can either give you an array formula for this thread or look at removing the array from the formula in the other thread.
Your choice.
Last edited by jason.b75; 07-15-2018 at 04:06 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks