Excel Formula Issue

I want to populate multiple values in a column based on different condition.. I have constructed a Excel formula, however, only first part of the formula is working. Need help!

By: Sam

One thought on “Excel Formula Issue

  1. Sam

    Col 1 | Start Date | Value populated using Formula
    CP26693 9/17/2018 Fulfilled If Col 1 is not blank, then Fulfilled
    blank 11/1/2018 More than 6 weeks If Col1 is blank and Start Date is more than 6
    weeks from today’s date
    blank 12/15/2018 Less than 6 weeks If Col1 is blank and Start Date is less than 6
    weeks from today’s date
    This is the table structure

Leave a Reply

Your email address will not be published. Required fields are marked *