View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Warm FL Warm FL is offline
external usenet poster
 
Posts: 4
Default 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?