Employee Calendar SUM Functions help (Weekends, Day OFF, Hollidays, e.g.)

[hackertom]

my workbook file its upload here : https://www.excelforum.com/attachments/excel-formulas-and-functions/589922d1536740825-sumproduct-function-help-max-value-zeszyt__2.xlsm

Night Work Hours :

I use this function to sum 6 hours or 5 hours :

=SUMPRODUCT((OFFSET($A8;0;31*($A$3-1)+1;1;31)<>"")*(IF(OFFSET($A8;0;31*($A$3-1)+1;1;31)=NO10;6;IF(OFFSET($A8;0;31*($A$3-1)+1;1;31)=NO11;5))))

]
i want help how system count to max value 48 (<=48) ?


Weekend Pay:

i want some help there when user add D on Sat or San then system count by 1, max counts = 4

Day OFF:

i want some help there when user add R count -1, if user add P or A or B on hollidays dates then count +1, if user add P or A or B on Sat or Sun then count +1


can anyone help me please?

 

[steve the fish]

Its doubtful id download a macro enabled file from a new user called 'hackertom' That said that site requires someone to be logged in so we cant see it anyway. Try pasting an example here.

 

[Fluff]

@hackertom
Please supply a link to the thread, not to the file. That way members here can see what help you have had on the other site.
Please see rule 13 along with the explanation: Forum Rules

 

[hackertom]

Its doubtful id download a macro enabled file from a new user called 'hackertom' That said that site requires someone to be logged in so we cant see it anyway. Try pasting an example here.

hahaha so funny but i am not a hacker this is only a name... check my file with all antivirus in the word, macro only change month in my workbook.........

 

[hackertom]

https://www.excelforum.com/excel-fo...5284-sum-function-count-help.html#post4973408

 

[Fluff]

Thanks for the link, but you need to supply a link to every site that you have asked this question on.
Please read this for an explanation Excelguru Help Site - A message to forum cross posters