1) what do you *think* this formula does, and what cell is it in?
=DATE(YEAR(E3),MONTH(E3),1+((1-(2=WEEKDAY(DATE(YEAR(E3),MONTH(E3),1))))*31)+ (2-WEEKDAY(DATE(YEAR(E3),MONTH(E3),1))))

2) what is in cells Q8, F16, and G16?
3) how do those cells relate to the formula above?
4) most important - in plain English, what are you trying to accomplish?
Maybe your approach is convoluted and the people here could help you
streamline the approach - but we need to have an idea of your objective, and
that doesn't come across in either of your posts


"hellsbells" wrote:

Hi Dave

I have set up the formula which will initially be used to set up a date this
then links to another field which will show this date. The information in
this field will then be linked to the field where we input the dates. if the
date is within the range then it will be highlighted but for some reason its
not highlighting it. If i changed the date to the end of the month then it
would highlight the section but if it is only part way through the month then
it leaves it blank.

here is a list of all formulas used:

"=DATE(YEAR(E3),MONTH(E3),1+((1-(2=WEEKDAY(DATE(YEAR(E3),MONTH(E3),1))))*31)+ (2-WEEKDAY(DATE(YEAR(E3),MONTH(E3),1))))"

=IF(AND(Q$8=$F16,Q$8<=$G16),1,"").

and just a general = cell before plus 30

Im not sure if im explaining myself properly - sorry if im not

Thanks

Helen


"Dave F" wrote:

It's not clear how to help because you don't tell us what is value is in each
of the cells in your formula. The formula's syntax is correct, so absent any
information about the values being tested, we can't help.

Give us more detail about what values work, what values don't work, etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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