If I understand and 1/7/2008 date is in cell L2
1st=TEXT(L2,"mm/dd")&"-"&TEXT(L2+2,"mm/dd yyyy") &" Mon,Tue,Wed"
2nd=TEXT($L$2+ROW(A1)*7,"mm/dd")&"-"&TEXT($L$2+ROW(A1)*7+2,"mm/dd yyyy") &"
Mon,Tue,Wed"
copied down
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cristella" wrote in message
...
I need to roll over dates from 2007 to 2008. Keeping the same days of the
week.
Example: 07/23-07/25 2007 mon,tues,wed. I need to keep Mon, tues, wed,
days
and change the date range to correspond with 2008