Thread: How I convert date formatt of dd/mm/yy to mm/yy (not cell format)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default How I convert date formatt of dd/mm/yy to mm/yy (not cell format)

You would have to convert the dates to the same date in a new column
something like assume date is in a2, you could put in b2

=date(year(a2),month(a2),1) would make all the dates in the same month
the same. You could then copy this formula down

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=522521

Reply With QuoteReply With Quote