Date selection

Options

Hi,

I have 2 dates columns. 1st is original date of delivery and 2nd is revised date of delivery.

1st column is always filled whereas we only fill 2nd column if their is a revised date.

Revised can be before or after original date of delivery.

How can I pick the revised date? I tried Max but it is picking latest date whereas revised date is now before original date.

Manpreet

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi,

    Try a variation of this using your column names.

    =IF(ISDATE(Revised@row), Revised@row, Original@row)

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi,

    Try a variation of this using your column names.

    =IF(ISDATE(Revised@row), Revised@row, Original@row)

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Thanks Mark,

    I also used similar formula in different way.

    =IF([Revised Delivery Date (Current Plan)]@row = "", [Agreed Upon Delivery Date (Original)]@row, [Revised Delivery Date (Current Plan)]@row)


    Manpreet

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Excellent. Glad you found a solution. Thank you for contributing to the Community.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.