If formula to identify data outside a timeframe
Closed
Wiebes
-
Feb 19, 2015 at 05:17 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Feb 19, 2015 at 05:57 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Feb 19, 2015 at 05:57 AM
Related:
- If formula to identify data outside a timeframe
- Identify painting - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- The system could not identify your location viber - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Feb 19, 2015 at 05:57 AM
Feb 19, 2015 at 05:57 AM
Hello Wiebes,
Perhaps this formula could help:-
=IF(A2="","",IF(B2="","",IF(B2-A2>=28,"Qualified",IF(B2-A2<28,"Not Qualified"))))
I'm assuming that the headings are "Created Date" in A1 and "Inception Date" in B1. Enter the formula in C2 (or wherever) and drag it down as far as you like.
I hope that this helps.
Cheerio,
vcoolio.
Perhaps this formula could help:-
=IF(A2="","",IF(B2="","",IF(B2-A2>=28,"Qualified",IF(B2-A2<28,"Not Qualified"))))
I'm assuming that the headings are "Created Date" in A1 and "Inception Date" in B1. Enter the formula in C2 (or wherever) and drag it down as far as you like.
I hope that this helps.
Cheerio,
vcoolio.
