• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional data population based on multiple date columns

krishnabsharma

New Member
Hi Team,
Greetings!

Need your help on issue i am facing -

Information: Have 6 Date columns (Date1 to Date6) and 2 resulting columns as "12M" & "36M" which are dependent on these 6 date columns.

Problem Statement:
  1. If any of 4 Dates columns out of 6 are less than a Years duration then "12M" should have "NonCompliant" else "Compliant"
  2. If any of the Dates columns out of 6 is less than a Years duration then "36M" should have "NonCompliant" else "Compliant"
e.g. Date1: 11-Apr-2015, Date2: 11-Apr-2014, Date3: 11-Jan-2014, Date4: BLANK, Date5: 11-Apr-2015 & Date6: 11-Apr-2015.
With this scenario, the value should be "Compliant" as minimum 3 columns are within a YEARS range.

Likewise it will be for "36M" outcome column. Each date column should be within a YEARS range then ONLY it will be a "Compliant".

Attached is the sample data.

Can you please help me get this completed? Thanks.


Regards,
Krishna
 

Attachments

  • Date_Formula.xlsx
    12.5 KB · Views: 1
Back
Top