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

**jpergega** · 03-18-2015, 12:41 PM

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:

If deadline > today()  then
 30 days before the deadline show message "Due in one Month" in the cell 
end

Help please!

Thank you

**Richard Buttrey** · 03-18-2015, 12:51 PM

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

Formula:

=IF(A2-$A$1<30,"XX","")

alternatively put a cond format in A2

Formula:

=A2-$A$1<30

**jpergega** · 03-18-2015, 12:53 PM

Hi

Thanks for your quick reply.

Even better without the macro.

Cheers

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Get Back "#N/A" When work out "relative ratio" by PIVOT's "Show Value as /Difference from"

"IF()" function using "TODAY()" to produce a value in days

MSoffice Outlook 2003 message to be saved in C dir with the file name "From" "Sent" "Sub"

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working

Is there an easy way to calculate # of "work days" in a month?

Bookmarks

Bookmarks

Posting Permissions