Counting Weekdays

DaKen · May 15th, 2002, 08:12 AM

I need a formula to count the # of weekdays so far in the month. For instance, I have a cell that is "=today()" giving me todays date. From that I want another formula to count the # of weekdays month to date.

Thanks for your help
Doug

Steve Hartman · May 15th, 2002, 08:13 AM

try =NETWORKDAYS()

Aladin Akyurek · May 15th, 2002, 08:19 AM

Quote:

On 2002-05-15 07:12, DaKen wrote:
I need a formula to count the # of weekdays so far in the month. For instance, I have a cell that is "=today()" giving me todays date. From that I want another formula to count the # of weekdays month to date.

Thanks for your help
Doug

=NETWORKDAYS(A1,EOMONTH(A1,0))

where A1 houses the formula =TODAY().

Both NETWORKDAYS and EOMONTH are available if the Analysis Toolpak add-in is activated (thru Tools|Add-Ins).

Mark W. · May 15th, 2002, 08:35 AM

=NETWORKDAYS(TEXT(A1,"m-yy")+0,A1)

where A1 contains =TODAY()

DaKen · May 15th, 2002, 08:46 AM

Thanks to all. I've got it done!!

Doug

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 08:12 AM	#1
DaKen New Member Join Date: Feb 2002 Posts: 43	I need a formula to count the # of weekdays so far in the month. For instance, I have a cell that is "=today()" giving me todays date. From that I want another formula to count the # of weekdays month to date. Thanks for your help Doug

May 15th, 2002, 08:13 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	try =NETWORKDAYS()

May 15th, 2002, 08:35 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=NETWORKDAYS(TEXT(A1,"m-yy")+0,A1) where A1 contains =TODAY()

May 15th, 2002, 08:46 AM	#5
DaKen New Member Join Date: Feb 2002 Posts: 43	Thanks to all. I've got it done!! Doug