Hi
Is it possible to add a formatted month to a preceding month with two
columns formatted for text between?

Eg: Cell A1= the full date (1st Jan 2007), C4= A1 and formats to "Jan",
Cells D4 & E4 formatted for text, cell F4 = "Feb" and so on....

It can be in VBA or Macro if necessary.
Many thanks
--
Cosmo