How many days left in the current month

if i understand your requirement correctly, you would like to know the total number of workdays left in a month, considering that you work Monday through Saturday. if i have got that right, then try the following - inspired by @daddylonglegs:

put today's date (using CTRL+; or TODAY() function) or any other date in cell A1, then put this formula in B1 to get remaining workdays:

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6,7})+(EOMONTH(A1,0)-A1))/7))

for total workdays within that month - since the beginning of the month, try this in C1:

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6,7})+DAY(EOMONTH(A1,0)))/7))

these will work only if you have Analysis Toolpak installed.

the array {2,3,4,5,6,7} stands for Monday through Saturday.



EDIT:

in case someone wants to use these without dependency on other cells:

=SUM(INT((WEEKDAY(TODAY()-{2,3,4,5,6,7})+(EOMONTH(TODAY(),0)-TODAY()))/7))

=SUM(INT((WEEKDAY(TODAY()-{2,3,4,5,6,7})+DAY(EOMONTH(TODAY(),0)))/7))