"Don Guillett" wrote in message
...
: show nearst of two dates in new cell on excel

Don,

Either you have lost me there or you are pointing out that it would have
been more correct for me to have written:

are 7 days apart then the formula can be shortened to show nearst of two
dates in new cell on excel

If it is the latter then watch out for Debra Dalgliesh who will no doubt
point out that it should have been:

are 7 days apart then the formula can be shortened to show nearer of two
dates in new cell on excel

<g

--

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk