| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
show nearst of two dates in new cell on excel
trying to show the nearest date to present date from chose of two cells
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
show nearst of two dates in new cell on excel
=IF(ABS(A1-TODAY())<=ABS(B1-TODAY()),A1,B1)
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "matt clarke" wrote in message ... trying to show the nearest date to present date from chose of two cells |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
show nearst of two dates in new cell on excel
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 with @tiscali.co.uk "matt clarke" wrote in message ... trying to show the nearest date to present date from chose of two cells |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
show nearst of two dates in new cell on excel
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| How turn on excel functn, dbleclick on cell 2 show reference? | Setting up and Configuration of Excel | |||
| EXCEL: IF CELL B6 RED, HOW DO I GET A "W" (ie for win)to show up | Excel Worksheet Functions | |||
| Getting Excel on new computer to show dates like on old | Excel Discussion (Misc queries) | |||
| How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
