| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF formula to flag exp dates
How do I use the IF formula to display "DUE" 30 days prior to a date in excel?
|
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
THANK YOU SO MUCH! I was inputting the formula incorrectly. IT WORKS!
"Ken Hudson" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Continuous Services Dates | Excel Worksheet Functions | |||
| formula to find and flag dates older than 30 days | Excel Worksheet Functions | |||
| Formula including dates | Excel Worksheet Functions | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
