I would do this in two steps:
1. Put actual dates in C1 to N1. Use a format of "mmm" which will display
the 3-character month name.
2. To get the X's, use:
=if(and(month(c$1)=month($a2),month(c$1)<=month($ b2)),"X","")

Regards,
Fred

"Robert R" wrote in message
...
Hello, I have been tasked with trying to do the following

Column A - Date
column B -Date

A will always be earlier than B

columns C-N will be labeled months Jan-Dec

What I need to do is determine if the date between column A and B includes
the given month in column C - N and return a value of X.

ie...
A B C D E F
Jan Feb Mar Apr
1/1/10 3/12/10 X X X blank

I can then count the X values.

Any help would be greatly appreciated.
--
Thank you for your assistance!
Rob