Apr 03 2021 02:26 AM
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.
Apr 03 2021 03:21 AM
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
Apr 03 2021 01:06 PM
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
Apr 04 2021 03:08 AM