If formula to identify data outside a timeframe Closed

Question

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, 


Configuration: Windows / Chrome 40.0.2214.111

vcoolio · Answer

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.

If formula to identify data outside a timeframe

1 response

Similar discussions

Subscribe To Our Newsletter!