View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DB Explorer
 
Posts: n/a
Default Dislpay count of workdays in a month?

I have an excel sheet with the month and year in the A row..Like

Jan-06 Feb-06 Mar-06 Apr-06

How do i insert a formula in B row, to display the number of weekdays
in that corresponding month, like this?

Jan-06 Feb-06 Mar-06 Apr-06
22 20 23 20

Please advise

Cheers
Sunny