View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ktbull ktbull is offline
external usenet poster
 
Posts: 4
Default Sorting Dates when there are zeros in the month and/or day

I need to sort a column of date values that contain valid dates (i.e.
12/12/1990) as well as dates that contain zeros in the month and or in the
day (i.e. 01/00/1990 and 00/01/1990). I have managed to blend the missing
day dates into the range using mm/yyyy as my format, but I can not get the
dates with the missing months to incorporate. Any tips?

Thanks in advance.