Thread: Help Please
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
santaviga santaviga is offline
external usenet poster
 
Posts: 178
Default Help Please

Can someone give me a formula to extract the month from a date entry and
count the total number of times this is an enrty onto another sheet. e.g.
01/01/2006, I need to extract the middle 01 and have it in as a total under
Jan on another sheet, Can anyone tell me a formula to do this, I have tried
everything that I know of anyone any ideas????

Mark