If formula to identify data outside a timeframe

Closed
-
Posts
1334
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 28, 2022
-
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

Posts
1334
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 28, 2022
243
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.