Days of the Month

[ms7165]

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.

 

[pplstuff]

What version of excel? For example 2007 and 2010 have a function "eomonth", which may be a starting point.

 

[ms7165]

Sorry, 2010

 

[Jonmo1]

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)

 

[barry houdini]

=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))

 

[ms7165]

all I get with this formula is "False". Remember, Excel is not a strength so I am likely doing something incorrectly.

 

[ms7165]

I believe this is going to work. Will interesting to see what happens in the morning. Thanks to all.