Is there an easy way to calculate # of "work days" in a month?

[shadestreet]

I'm sure there is, just haven't figured out how.. suspecting somthing to do with the "workday" formula, but not sure how to use it right.

thanks in advance

[VBA Noob]

Hi,

Try

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6))

or networkdays (See link)

http://support.microsoft.com/kb/259200

VBA Noob

[mudraker]

Have a look at

Use Datedif
Have a read of Chips page ob this function

http://www.cpearson.com/excel/datedif.htm

A1 = 1/10/2006
B1 = 1/11/2006

=DATEDIF(A1,B1,"d")-1