Converting Older Dates to Current Year
 

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

Converting Older Dates to Current Year
 

Just add 364 to the date?

--
---
HTH

Bob

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



"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

Converting Older Dates to Current Year
 

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