IF function query - At 30 days before a end day show message "Due in one month"

[jpergega]

Hi

I want the excel to show message in a cell automatically when it reaches 30 days before the deadline:

My data in excel sheet:
Deadline
01/07/2015
02/07/2015

I am not sure how to write the code after the condition:

Please Login or Register  to view this content.

Help please!

Thank you

[Richard Buttrey]

Hi,

Do you really need a macro. You can do this with a normal excel function or apply a conditional format to the date cells so that they turn red when they are less than 30 days or so before the deadline.

With a deadline date in A1, and another date in A2, enter in B2

Please Login or Register  to view this content.

alternatively put a cond format in A2

Please Login or Register  to view this content.

[jpergega]

Hi

Thanks for your quick reply.

Even better without the macro.

Cheers