DATEDIF Formula HELP

Trying to calculate date between A5 and the earliest date in X5, M5 or G5

The formula below I have isnt working.

=(DATEDIF(A5,G5,"d"))*OR(DATEDIF(A5,M5,"d"))*OR(DATEDIF(A5,X5,"d"))

Please help!

Hi Forrest,
You could try using

Please Login or Register  to view this content.

Cheers
Sergio

Try it this way:

=DATEDIF(A5,MIN(G5,M5,X5),"d")

Hope this helps.

Pete

Thank you so much!