--

HTH

RP
(remove nothere from the email address if mailing direct)


"Grey" wrote in message
...
If I have a cell with the number of a month and a year, how can I produce
a
formula which will...

1. Return the number of days in that month.

=DAY(DATE(A1,B1+1,0))


2. Calculate the number of specific days of the week in that month (e.g.
how
many Tuesdays in Feb 2006)

=INT((DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,2))
)+6)/7)

where the 6 refers to the day number, 1 = SUn, etc


If I have two dates, how can I calculate how many working days (mon-fri)
between them?

=NETWORKDAYS(A1,A2,holidays) where holidays is a list of holiday dates