Forum Discussion

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 ...

Book1.xlsx12 KB

excel

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

Sunday_Holiday.xlsx12 KB

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.