Assuming that cell A1 contains a date, the following formula in B1 will place
"DUE" in B1 if the A1 date is exactly 30 days from today's date.

=IF(A1-TODAY()=30,"DUE","")

You might consider changing the formula to -

=IF(A1-TODAY()<=30,"Due","")

i.e. less than or equal to 30 days.

HTH


--
Ken Hudson


"wastedwings" wrote:

How do I use the IF formula to display "DUE" 30 days prior to a date in excel?