| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing Out a Month from a date field
In a field, I have the date 1/1/2008, but I only want to know that is was
JANUARY. Because I want to know if the current month is ,< or = the month that is in that field. This is being used when comparing previous years sales activities. So if I got the order in Jan 15, 2008 for my annual product, then I would expect my new order to come in Jan 2009 (but not necesarily on the 15th). Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show the current month in a date field? | Excel Discussion (Misc queries) | |||
| parsing a date field | Excel Discussion (Misc queries) | |||
| Converting a date field into a month-year only field | Excel Discussion (Misc queries) | |||
| Extracting month from a date field | Excel Discussion (Misc queries) | |||
| In Excel, look at a date field and return just the month.. | Excel Discussion (Misc queries) | |||
Threaded Mode
