Thread: Adding months
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Peter is offline
external usenet poster
 
Posts: 349
Default Adding months

In sheet 2 I'm creating at a glance information from the main sheet 1. In
column F is my dates, Example is 6/15/2006. I would like to create a formula
that will tell me how many cells have January 2006, February 2006, etc. all
the way to 1996. Can anyone help with this formula?

Thanks

Pete