View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default last day of the month in a range

Not sure what the question is but if you use =MAX(a1:a4) it will return the
last date of range. But I suspect this is not want you want?

--
Cheers
Nigel



"barkiny" wrote in
message ...

in column A there are dates like

01/15/2004
01/25/2004
02/03/2004
16/03/2004