View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default Finding the Latest Date from Several Dates in Different Columns

Hi

Dates are stored by Excel as serial numbers, therefore the latest date will
be the highest number
Try
=MAX(A1:C1)


--
Regards

Roger Govier


"sdupont" wrote in message
...
Can someone help me with a formula? I'd like to create a new column into
which I can put a formula that looks at dates in 3 other columns and puts
the
most recent date from the 3 into the new column? Thanks!
--
sdupont