Need help on Aging formula

[vijavad]

Hi Folks,

I have 3 columns wit different dates and i want to write a formula in 4th column and my condition is to calculate the aging whichever is the latest date among the three columns.

Formula needs to calculate aging from =TODAY()- Latest among the 3 columns dates.

 

[MPaul100]

Try
=TODAY()-MAX(A2:C2)

 

[vijavad]

Paul really appreciate for your help and swift response . Thank U SO MUCH