Converting Older Dates to Current Year


G

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
 
Ad

Advertisements

B

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)
 
Ad

Advertisements

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top