Quote Originally Posted by Special-K
You can certainly define month start end dates but you proably cant use the MONTH function using them dates. You might need to use some form of LOOKUP using the dates you've defined.
Oh, ok...so are you suggesting to use a VLOOKUP with a table array of the few dates that are the exception to the calender months? (e.g. 08/27/07 = SEPTEMBER, 08/28/07 = SEPTEMBER, etc.)