Dates

[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.

 

[Peo Sjoblom]

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

 

[Tami]

Hi Peo,

Not sure if I understand exactly. All of my dates are in
column D337. 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

 

[Peo Sjoblom]

Tami,

if I create dates in D337,then select D337 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?

 

[Tami]

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

 

[Peo Sjoblom]

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

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

 

[Tami]

This is exactly what I wanted. Thanks so much for all
your help.

Tami

 

[Peo Sjoblom]

My Pleasure

--

Regards,

Peo Sjoblom

This is exactly what I wanted. Thanks so much for all
your help.

Tami