Days until the later of two dates

Dave Schierman

Trying to figure out how to calculate the number of days from today to the later of two date columns. This will be used to determine number of days until the date in column named "Expirations Date" unless there is a date in the "Extension Date" column in which I would use that instead. Hope that makes sense.

Thanks

D

Dave Schierman

Ah, figured it out.

=IF([Extension Date]@row > [Expiration Date]@row, [Extension Date]@row - TODAY(), [Expiration Date]@row - TODAY())

Dave Schierman

Ah, figured it out.

=IF([Extension Date]@row > [Expiration Date]@row, [Extension Date]@row - TODAY(), [Expiration Date]@row - TODAY())