gymwrecker
Active Member
- Joined
- Apr 24, 2002
- Messages
- 390
- Office Version
- 365
- Platform
- Windows
- MacOS
=IF(TODAY()-A1>30,"LATE","DUE") Note: This is the formula in A2
Now, I need the following:
A2 be blank only when the date in A1 is not within 30 days from today; once it falls within those 30 days, it will start showind as "DUE".
In other words: I'm working with reports that are due 30 days out from when they expire (A1 in this case). If the report is over 30 days, then it is a "LATE" report. Now, reports that are not within the 30 days, they're not either late or due, they are OK. Thanks for your help!!!!
Now, I need the following:
A2 be blank only when the date in A1 is not within 30 days from today; once it falls within those 30 days, it will start showind as "DUE".
In other words: I'm working with reports that are due 30 days out from when they expire (A1 in this case). If the report is over 30 days, then it is a "LATE" report. Now, reports that are not within the 30 days, they're not either late or due, they are OK. Thanks for your help!!!!