In case you are not one of the mind readers around here and cannot read my
mind, enter the formula in A41 and drag down to A43 on the fill handle.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
If you mean dates and not just numbers then in A40 enter the date for the
28th day of the month. In A41 enter:

=IF(A40="","",IF(MONTH(A40)=MONTH(A40+1),A40+1,"") )

this will return empty strings if for date the *would* have been in the
following month.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Amber" wrote in message
...
I have a column filled with sequential dates. Cell A41 will always be the
30th day of a month, cell A42 will be EITHER the 31st day of that month
OR
the first day of the next month. IF A42 is the first day of a month I
would
like to format it with white text. I understand how to use conditional
formatting (change text color) but what should the condition state? I
tried;
"If the cell value is less than =DAY(31)" but that's not right.