Poolshark25
New Member
- Joined
- Jan 3, 2019
- Messages
- 31
Hi all
My apologies, i'm quite new to excel formulas.
I need to create an If formula in my training spreadsheet that will display "Retrain" when the training renewal date is within 7 days of todays date. I also want it to display "Not due" when the renewal date is either/or, more than 7 days of todays date or is not due to be retrained until a future date in a "Status" column.
Alternatively, which would be more ideal, i would like it to display "Retrain" when the date is within 7 days of todays date, "Not Due" when the renewal date is more than 7 days before todays date and "Overdue when the renewal date is past todays date.
So far i have managed to do the following code which does part of my outcome but am struggling with the rest of it:
=IF(DAYS(TODAY(),C9)<7, "Retrain")
The above works so far as returning "Retrain" when the date approaching is within 7 days of todays date but is also returning "Retrain" for renewal dates in the future which is no what i want.
Could anyone please help with the correct formula to achieve my 3 outcomes, as in paragraph 2?
My apologies, i'm quite new to excel formulas.
I need to create an If formula in my training spreadsheet that will display "Retrain" when the training renewal date is within 7 days of todays date. I also want it to display "Not due" when the renewal date is either/or, more than 7 days of todays date or is not due to be retrained until a future date in a "Status" column.
Alternatively, which would be more ideal, i would like it to display "Retrain" when the date is within 7 days of todays date, "Not Due" when the renewal date is more than 7 days before todays date and "Overdue when the renewal date is past todays date.
So far i have managed to do the following code which does part of my outcome but am struggling with the rest of it:
=IF(DAYS(TODAY(),C9)<7, "Retrain")
The above works so far as returning "Retrain" when the date approaching is within 7 days of todays date but is also returning "Retrain" for renewal dates in the future which is no what i want.
Could anyone please help with the correct formula to achieve my 3 outcomes, as in paragraph 2?