IF formula to flag exp dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use the IF formula to display "DUE" 30 days prior to a date in excel?
 
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
 
THANK YOU SO MUCH! I was inputting the formula incorrectly. IT WORKS!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting expiry dates 1
Workday Formula to include date 0
Please help with formula (multiple ifs to determine due date) 3
Happy Anniversary Flag? 4
Testing a cell value for a specific weekday. 3
How to create one additional warning flag into my logic? 1
Help neededin adding an additional "Warning Flag" to my current lo 1
formula to change font or cell colour 3

Back
Top