Help with dates

Hello everybody.

I need a help related to formulas with dates.

I have a start date (10/02/2014) and an end date (30/10/2014) when compared with the date "eg: Jan / 14 must show" 0 "on the worksheet, where to Feb/14 should show "1" until Oct/2014.

Ex:

Start date End date jan/14 fev/14 mar/14 abr/14 mai/14 jun/14 jul/14 ago/14 set/14 out/14 nov/14 dez/14 jan/15 fev/15 mar/15
10/02/2014 30/10/2014 0 1 1 1 1 1 1 1 1 1 0 0 0 0 0
06/12/2013 30/05/2014 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0
02/10/2013 30/03/2014 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0

Thanks.

will you pls attach sample excel file

Perhaps something like this...

=IF(and($A2>=A$1,$B2<=A3),0,1)
(untested)

this, copied down and across, gives you what you have...
=IF(AND(E$2>=$B3,E$2<=$C3),1,0)

Check your F3 though, you say 1, but i think it should be 0?

OK, try this instead...
=IF(AND(E$2>EOMONTH($B3,-1),E$2<=$C3),1,0)

=--(MEDIAN(EOMONTH($B3;-1)+1;$C3;E$2)=E$2)
Try this one

Happy to help, thanks for the feedback