It sure would make it easier if you gave us some details with which to work.
We could make all kinds of guesses about what works and what doesn't, but
they would only be guesses


"hellsbells" wrote:

I am writing a formula which will highlight cells with regard to specific
dates that have been put on the spreadsheet, however I can get it to work for
most of it but if the date is only a part way though the month it will not be
highlighted. I need it to be included - do you have any ideas how to get it
to work. The formula i am using is =IF(AND(Q$8=$F16,Q$8<=$G16),1,"").

Thanks for your help