Hi

With any date from month searched for in cell A1
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0)
formatted as Number or General


Arvi Laanemets


"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan