I'm running a spreadsheet to show recruitment campaigns at stores. I have
'start date' in one colum, 'end date' in next column. I have dates of month
in following columns. I've tried a formula in conditional formatting to turn
the relevant dates in a campaign 'shaded', if they fall within the start and
end dates. But the formatting fails on the final day of a campaign, unless it
happens to be the last day of the month. Here's the formula I'm using:

=IF(LEN(F$6)0,AND(E$6=$C7,F$6<=$D7),E$6<=$D7)

Can anyone help adjust this so that the final date of the campaign always
becomes "shaded", please?