date comparison

[drumsab]

Hi,
I have two dates, one in cell A1 and one in cell B1 (start date and end date). The format is mm-cc-yy.

What I want for cells C2, D2, E2 and F2 is this:
if the year/mon in C1 is = or in between the year/mon of A1:B1, I wnt to set a value of 1 in C2, if not, then set a value of 0.

The resulting "formula" in cells C2, D2, E2 and F2 would then return the values shown in C3, D3, E3 and F3.

Your help is appreciated !

A B C D E F
1 03/01/2010 05/15/2011 10-Feb 11-Jan 10-Oct 11-Aug
2 0 1 1 0
3
4
5

 

[jasonb75]

Try

=--(C1=MEDIAN(C1,EOMONTH($A$1,-1)+1,EOMONTH($B$1,0)))

 

[drumsab]

thanks very much !

 

[drumsab]

I see in your formula you have a =--(

I haven't see the -- before. What does that signify?

 

[jasonb75]

It coerces logical results, i.e. TRUE / FALSE into 1 / 0 respectively, in effect it's the same as

=IF(C1=MEDIAN(C1,EOMONTH($A$1,-1)+1,EOMONTH($B$1,0)),1,0)