Date selection

Manpreet Singh Manchanda

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

Mark Cronk

Hi,

Try a variation of this using your column names.

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

Mark

Mark Cronk

Hi,

Try a variation of this using your column names.

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

Mark

Manpreet Singh Manchanda

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

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

Mark