Highlight Dates within Range

[ARJUNDSOUZA]

Dear Excel Gurus,

From the attached sheet, I want to set a formula where in lookup for date range between Cell A2:B2 in G1:UE1, then go to G2:UE2 and make cell values = 1.

Appreciate your guidance

Kind regards
Arjun

 

[Excel Wizard]

Please try at D2
=N(MEDIAN($A1,$B2-1,D$1)=D$1)
Hide Zero by custom format #

or
=IF(MEDIAN($A2,$B2-1,D$1)=D$1,1,"")

 

[ARJUNDSOUZA]

Awesome, Thank you @Excel Wizard.
The formula does exactly what I was looking for.