View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John R.[_3_] John R.[_3_] is offline
external usenet poster
 
Posts: 1
Default need to split month out from date formatted cell

Hi, I have a workbook that is used throughout the company.
My boss wants to report on certain fields based on month.
The only problem is that all cells with a date in them are
all mm/dd/yy. I want to present my boss with a userform
that will ask her what month she wants, then go to any
worksheet and get the information she needs.

How can I query the date cells with only a 2 digit month?

Thanks