Forum Discussion

Ashutosh_Dwivedi's avatar
Ashutosh_Dwivedi
Copper Contributor
Apr 03, 2021

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 ...
excel
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Apr 03, 2021

Hi Ashutosh_Dwivedi 

 

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

  • Ashutosh_Dwivedi's avatar
    Ashutosh_Dwivedi
    Copper Contributor
    Apr 04, 2021
    Thanks Mr. Tauqeer
    I've use this formula so many times different equations but don't think to apply this formula in salary sheet.

Resources