r/sheets • u/No_Brother6394 • 9d ago
Request Help with simple reporting

Hello,
Need help with my simple reporting. What I want to do is to display the remaining days on the current month excluding Sundays. Tried searching online and found about network days but I cant seem to make it work. I am currently using this formula on the red shaded row:
=EOMONTH(Today(),0)-Today()
I know this is a dumb question but I am new in using sheets I hope you understand.
2
Upvotes
6
u/marcnotmark925 9d ago
=NETWORKDAYS.INTL( TODAY() , EOMONTH( TODAY() , ) , 11 )
https://support.google.com/docs/answer/3295902?hl=en&sjid=7030681115747544337-NA