Just thinking about it, if you wanted say Jan in a1, Feb in A6, then try

=TEXT("2007-"&INT(ROW(A1)/5)+1&"-01","mmm")

and copy to A6.

If you want to start at May, change A1 to A25 (month number * 5)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Rubber 4 u" <Rubber 4 wrote in message
...
i want to just enter a month (text) in a cell, then have it automaticly
enter
in sequence the following 4 months, there is info in 5 cells between each
month. how do i accomplish this