On Aug 27, 2:14*pm, David Stephenson
wrote:
Hi,

I am trying to find out how to look at two dates and return a value in the
months the dates relate to.

Example

* * * * * * * * Jun-08 *Jul-08 *Aug-08 *Sep-08 *Oct-08 *Nov-08 *Dec-08 *Jan-09
Start * End * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
01/09/2008 * * *30/11/2008 * * *0 * * * 0 * * * 0 * * * 1 * * * 1 * * * 1 * * * 0 * * * 0

--
Steva

Assuming the column heading dates are 1st of the month, but formatted
to 'mmm-yy' format, and the range shown above starts in A1 (so
'Jun-08' is in C1 and '01/09/2008' is in A3) put the following formula
in C3 and copy to wherever you wish ...

=IF(AND(C$1=$A3,C$1<=$B3),1,0)

Hope this helps,

Rob