Dates

  • Thread starter Thread starter Tami E.
  • Start date Start date
T

Tami E.

I have a worksheet that contains a column with dates. Is
there a formula or macro I can create to highlight the
next months dates? Example this is the month of January,
in the column I want all Feb dates to be highlighted and
continue this way for the following months.

Thanks for all your help.
 
Select all dates, assume that the dates start in A2 ending in L31
select the lot, with A2 as the active cell do format>conditional formatting,
select formula is and use

=AND(MONTH(A2)<>MONTH(TODAY()),A2>TODAY())

select formats and click OK twice
 
Hi Peo,

Not sure if I understand exactly. All of my dates are in
column D3:D37. I tried what you suggested, but it didn't
do anything. I selected the all the cells that contain
dates then clicked on Format/Conditional formatting,
selected formula is and used
=AND(MONTH(A2)<>MONTH(TODAY()),A2>TODAY())
and replace A2 with D3. I selected formats and choice a
color to highlight the specific dates then clicked ok
twice. Is there something I missed????

I am not sure exactly how to read this formula? Further
explaination would be helpful.

Thanks
Tami
 
Tami,

if I create dates in D3:D37,then select D3:D37 with the mouse starting form
D3, then use formula is

=AND(MONTH(D3)<>MONTH(TODAY()),D3>TODAY())

and select a pattern to high light with it works.

Maybe the dates are text?
 
This formula worked,but not exactly what I was looking
for. Is there a formula that will highlight just the next
month. Say I have one column full of dates ranging from
Jan through Dec. This is the month of Jan, I want just
Feb to be highlighted, when it is Feb - I want just Mar
to be highlighted and so on.

Thanks
 
That's easily fixed, do the same but use this formula instead

=MONTH(TODAY())+1=MONTH(D3)
 
Back
Top