Vlookup formula for dates please help

[pigment01]

hello,

I am trying find a formula that will compare Column D and W and if column W is ONLY 1 month past the date in column W I want it to highlight or make some mark in Column W. I am trying to eliminate the manual work here can someone please help me?

Thanks

[etaf]

I am trying find a formula that will compare Column D and W and if column W is ONLY 1 month past the date in column W I want it to highlight or make some mark in Column W

did you mean D

do you just want to compare the ROW
or will D2 date be compared to the entire column W
then D3 compared to entire column W ?

[pigment01]

did you mean D

In column D are the dates always the same?

In Column D, the dates are changing.

Column W is where I want a "markup" or highlight to occur if column W date is only 1 month past due from column D date for example

Column D Column W

1/20/15 02/01/15
01/05/15 01/07/15
11/01/14 12/01/14

All these dates would be highlighted because they are exactly 1 month over. So if its 2 or 3 months over they wont be highlighted.

[José Augusto]

Hi

Use conditional formating with the formula =OR(W2-D2<31,AND(W2-D2=31,MOD(MONTH(D2),12)+1=MONTH(W2)))

Regards

[pigment01]

Hi

Use conditional formating with the formula =OR(W2-D2<31,AND(W2-D2=31,MOD(MONTH(D2),12)+1=MONTH(W2)))

Regards

Hi I tried your formula for Column W and I am getting TRUE for all values which is not right because some dates the 1 month over is not true some of them are 2 months over and it was marking true

[newdoverman]

Try this:
Select column W then go to Conditional Formatting, New Rule, Use Formula... and enter this formula in the formula field:

Please Login or Register  to view this content.

Format with the formatting of your choice. OK OK, Apply. Close.

[pigment01]

Try this:
Select column W then go to Conditional Formatting, New Rule, Use Formula... and enter this formula in the formula field:

Please Login or Register  to view this content.

Format with the formatting of your choice. OK OK, Apply. Close.

Perfect Thanks so much!!