View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy_Pimp
 
Posts: n/a
Default Dates - Several Days In a month to month only


Problem below

14-Oct-06 £5,000
30-Oct-06 £15,000

How do I get this to show as:

Oct-06 £20,000

Is there a formula to do this?


--
Andy_Pimp
------------------------------------------------------------------------
Andy_Pimp's Profile: http://www.excelforum.com/member.php...o&userid=31990
View this thread: http://www.excelforum.com/showthread...hreadid=517243