Block the Dates in calendar with Numerical "1"

[Iksonm]

Hi

I have a situation not able to solve it.

I have multiple date band in 2 rows, visavis date range in columns as well.

I need to block the dates between the band range, in column with numerical 1

Ex.
01-11-2012 02-11-2012 03-11-2012 04-11-2012 05-11-2012 06-11-2012 07-11-2012 08-11-2012 09-11-2012 10-11-2012 11-11-2012 12-11-2012
01-11-2012 04-11-2012
05-11-2012 07-11-2012
08-11-2012 09-11-2012
01-11-2012 10-11-2012

So all the dates in between date band needs to be selected as 1

can someone please help in the same.

[Iksonm]

forgot to add i tried conditional formatting, but was only able to change colours, not emter numerical field. i need the numerical field as 1

[:) Sixthsense :)]

In C2 cell

Please Login or Register  to view this content.

Drag it down and right

[Iksonm]

Hi this is perfectly the way i wanted just a small change. in this even date band of B is showing as true, where as i need it as A to everything in between B. But not B

[:) Sixthsense :)]

Unable to understand your expectation, could you please explain it a little more with the expected output file.

[Iksonm]

well ok got it done had to add -1

thank you so much for your help.