If formula to identify data outside a timeframe

Closed
Wiebes - Feb 19, 2015 at 05:17 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Feb 19, 2015 at 05:57 AM
Hello,
I have a excel report that contains data including a date created and inception date. I would like to run a formula that will tell me if the entry is Qualified based on the created date being more than 28 days from the inception date ? eg1: Created Date 15/01/2015 and inception date 28/02/2015 = "qualified" eg2: Created Date 15/01/2015 and inception date 31/01/2015 = "Not Qualified"

Regards,


1 reply

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
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.
0