View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bismark
 
Posts: n/a
Default Matching numbers witin a series

A3 and A4 contain from and to dates.

B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05)
Subsequent Colums contain subsequent years.

I need help in trying to establish how many days within the dates specified
in A3 and A4 are also contained within the periods specified in each column.

I am using Microsoft Office XP.
--
Ron.