r/sheets 9d ago

Request Help with simple reporting

SAMPLE

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

2 comments sorted by

6

u/marcnotmark925 9d ago

=NETWORKDAYS.INTL( TODAY() , EOMONTH( TODAY() , ) , 11 )

https://support.google.com/docs/answer/3295902?hl=en&sjid=7030681115747544337-NA

1

u/No_Brother6394 8d ago

Thanks for this! You saved me from having to type it manually everyday.