Days of the Month

ms7165

New Member
Joined
Oct 10, 2008
Messages
16
from a challenged Excel user who has a cell that needs to countdown the days of the month but need the ability to automatically remove Sundays. In other words the cell needs to refresh daily to show the number of days that have passed thus far and automatically know to not include Sundays. This would just be a numerical value.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
What version of excel? For example 2007 and 2010 have a function "eomonth", which may be a starting point.
 
Upvote 0
Try

=NETWORKDAYS.INTL(TODAY()-DAY(TODAY())+1,TODAY(),11)

Note, that it includes today in the count.
If today should be excluded from the count, change it to
=NETWORKDAYS.INTL(TODAY()-DAY(TODAY())+1,TODAY()-1,11)
 
Upvote 0
=NETWORKDAYS.INTL(TODAY()-DAY(TODAY())+1,TODAY()-1,11)

On 1st of the month that will return a negative value (e.g. -2 on 1st June 2012) so you might want to amend to return zero as minimum value, i.e.

=MAX(0,NETWORKDAYS.INTL(TODAY()-DAY(TODAY())+1,TODAY()-1,11))
 
Upvote 0
all I get with this formula is "False". Remember, Excel is not a strength so I am likely doing something incorrectly.
 
Upvote 0
I believe this is going to work. Will interesting to see what happens in the morning. Thanks to all.
 
Upvote 0

Forum statistics

Threads
1,211,686
Messages
6,103,296
Members
447,853
Latest member
olddutch7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top