Converting Older Dates to Current Year

[Guest]

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

 

[Bob Phillips]

Just add 364 to the date?

--
---
HTH

Bob

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

 

[Don Guillett]

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