Hello Max
Gave yours a whirl but no joy for the moment. As in my reply to Roger, did
hope I could update F4 from C4 by one month
--
Cosmo


"Max" wrote:

Not sure but you could try this formulas play ..

With the commencement date in A1,

Put in C4:
=IF($A1="","",IF(MOD(COLUMN(A1),3)=1,TEXT(DATE(YEA R($A1),MONTH($A1)+INT((COLUMN(A1)-1)/3),1),"mmm"),""))
Copy C4 across as far as required

The above should return the required consecutive text "months" in C4, F4,
I4, etc depending on the date input in A1. In-between cells eg: D4:E4, G4:H4,
etc will appear blank.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cosmo" wrote:
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