Calendar or Workdays in a Month

[mdalby]

There doesn't appear to be a function that calculates the number o
calendar days or the number of work days (Monday-Friday) in a month.
Is there a formula I can use?

Thanks,

M

 

[Frank Kabel]

Hi
to calculate the days in a month use
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
If A1 stores a date

For working days in a month use
=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(A1),MONTH(A1)+1,0))

 

[DDM]

MD, install the Analysis Tool Pack add-in and check out the NETWORKDAYS
worksheet function. For more on this and other data and time related
functions, have a look at Chip Pearson's Website. Start here:
http://www.cpearson.com/excel/DateTimeWS.htm.

 

[mdalby]

--