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