Can anyone please helpw me with a formula to find out 'Working Day' from the Calendar Date.
For Eg. My Weekend holidays were on Fridays and Saturdays so that i need to get my holiday marked on those days and also my work starts from Mid Month henec we used to update working days as negative numbers as well as positive numbers.
We can Mark fridays and Saturdays as "H" or Can Leave blank.forum.ozgrid.com/index.php?attachment/71442/
Example as attached
Where im able to find out a formula the formula is =IF(A2=WORKDAY.INTL(A2-1,1,"0000110"),NETWORKDAYS.INTL($A$15,A2,"0000110"),"H")
However i want my lastday of the month as "-1" in the sheet but as per this formula where my last day is derived as "1" is it possibel to derive it as "-1".