G
Guest
trying to show the nearest date to present date from chose of two cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=IF(ABS(A1-TODAY())<=ABS(B1-TODAY()),A1,B1)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
S
Sandy Mann
What if the two dates are the same amount of days away?
=IF(ABS(TODAY()-A1)=ABS(TODAY()-A2),"Either
Date",IF(ABS(TODAY()-A1)=MIN(ABS(TODAY()-A1),ABS(TODAY()-A2)),A1,A2))
If they can never be the same number of days away from today like if they
are 7 days apart then the formula can be shortened to:
=IF(ABS(TODAY()-A1)=MIN(ABS(TODAY()-A1),ABS(TODAY()-A2)),A1,A2)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
=IF(ABS(TODAY()-A1)=ABS(TODAY()-A2),"Either
Date",IF(ABS(TODAY()-A1)=MIN(ABS(TODAY()-A1),ABS(TODAY()-A2)),A1,A2))
If they can never be the same number of days away from today like if they
are 7 days apart then the formula can be shortened to:
=IF(ABS(TODAY()-A1)=MIN(ABS(TODAY()-A1),ABS(TODAY()-A2)),A1,A2)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
D
Don Guillett
: show nearst of two dates in new cell on excel
S
Sandy Mann
Don Guillett said:: 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:
If it is the latter then watch out for Debra Dalgliesh who will no doubt
point out that it should have been:
<g>
--
Sandy
In Perth, the ancient capital of Scotland
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk