Formula or Formatting to return a value based on a date and 18 weeks in the future from that date

[TThorn]

Hi All,

I am new here and admittingly not the greatest using excel.

I am having some issues with a workbook that I am currentlyworking on.
I need a formula that looks between 2 date ranges to returna value.
E.G - If the received date is 18 weeks from the running timethe value is compliant, if it is before 18 weeks the value is non compliant
Would appreciate any insight on how I go about achievingthis

Thanks

 

[excel_learnerz]

B1 will be the received date and A1 will be the start date, based on what you said about being 18 weeks or more its compliant and less than 18 weeks its non compliant

=IF((DAYS(B1,A1))/7>=18,"Compliant","Non compliant")

 

[Kerryx]

=IF(DAYS(TODAY(),A2)>126,"Non-Compliant","Compliant")

 

[TThorn]

Thank you