Trying to calculate- compares two dates, chooses later date, tells days to current date

[Vicious00013]

Lets say we have two dates.
One date is the scheduled date of arrival and the second date is the actual arrival date.
We are trying to calculate days in shop from which ever of those dates is the later date.
So I am trying to figure out how to compare the two dates, choose the latest of the two and then calculate the number of days between that date and the current date.

[Kaper]

Please Login or Register  to view this content.

format as general, because excel will probably try to format automatically the cell with formula as date.

[Vicious00013]

Please Login or Register  to view this content.

format as general, because excel will probably try to format automatically the cell with formula as date.

Thanks a ton Sir. It did the trick.
I appreciate it.

[Kaper]

Glad to hear that
And thanks for marking thread Solved and for Reputation :-)

If I could kindly ask you also to observe Rule 12 of our http://www.excelforum.com/forum-rule...rum-rules.html

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding