How to get the following data ... How to create the formula for below

[Gowtham Raj Charugundla]

If I enter the start and end dates if should highlight with color in corresponding rows (C to H) with count as 1


A B C D E F G H
start End Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13
18-Jul-13 8-Aug-13
21-Jul-13 16-Aug-13
28-Jul-13 20-Aug-13
1-Aug-13 2-Sep-13
30-Jul-13 31-Aug-13
4-Aug-13 5-Sep-13

 

[isabelle]

hi Gowtham Raj Charugundla,

copy the next formala in range C2 to return 1 or 0
=IF(AND(MONTH(C$1)>=MONTH($A2),MONTH(C$1)<=MONTH($B2)),1,0)
then copy to the right and down


select range C2:H7
conditional formatting => use formula
=AND(MONTH(C$1)>=MONTH($A2),MONTH(C$1)<=MONTH($B2))

isabelle


Le 2013-09-20 08:30, Gowtham Raj Charugundla a écrit :