| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell formatted as date won't change | Excel Discussion (Misc queries) | |||
| Extract the Month from a cell with a formatted date | Excel Discussion (Misc queries) | |||
| Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y | Excel Discussion (Misc queries) | |||
| Extracting date from Date and Time formatted cell | Excel Discussion (Misc queries) | |||
| how do i add 1 year to a date formatted cell? | Excel Worksheet Functions | |||
![John R.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
