Hi, this seems like it should be straightforward but I can't work it out.
I have a list 1st of the month for each month of the year in column A. I then have a list of 42 days in the rows (ie, 01, 02, 03) that ties up with the appropriate day in the month. Is there is simple way to highlight those dates that are outwith the month or highlight the dates that are only within the month?
I tried =MONTH(D2)<>MONTH(A2) where D2 is the start of the range of dates for the month and A2 is where the first of the month is listed. I thought this would highlight the days outwith the month but its returning a random highlight.
Any thoughts on this?
Thanks
I have a list 1st of the month for each month of the year in column A. I then have a list of 42 days in the rows (ie, 01, 02, 03) that ties up with the appropriate day in the month. Is there is simple way to highlight those dates that are outwith the month or highlight the dates that are only within the month?
I tried =MONTH(D2)<>MONTH(A2) where D2 is the start of the range of dates for the month and A2 is where the first of the month is listed. I thought this would highlight the days outwith the month but its returning a random highlight.
Any thoughts on this?
Thanks