Forum Discussion
SUNDAY CALCULATION
Dear sir
when we were preparing the salary sheet every time we have to replace cell reference work. So we want to know how to do a shortcut way to add all Sunday in monthly sheet. if you have any formula regarding the auto-identify the "S" and go down the same cell where is representing the employee duty like (absent or Present ), and calculate the Sunday or Holidays. We are using the 0 is present & "A" is absent.
{0=1, A=0}
file is attached for your reference.
4 Replies
What Mr. tauqeeracma sent you should be enough for you to plan.
Nonetheless, with everyone's permission,
I am sending you an old file that I made a long time ago as a vacation planner
in addition to Mr. tauqeeracma suggestion,
maybe that will give you additional ideas.
Some things in the file are in German, it would have to be changed a little to meet your needs and translate :).
Thank you for your patience and understanding
Nikolino
- Yes that's enough.
thankyou
For Sunday use
=COUNTIFS($B$2:$AF$2,"S",B3:AF3,0)and for Holiday use
=COUNTIFS($B$2:$AF$2,"H",B3:AF3,0)File is also attached for your reference. Please let me know if it works as desired.
Thanks
Tauqeer
- Thanks Mr. Tauqeer
I've use this formula so many times different equations but don't think to apply this formula in salary sheet.
