Hi Carrie,
Excel has a weeknum() function in the analysis toolpak addin. (toolsaddins...)
There are also several ISOweeknum functions. A google search should bring up several dozen.

John

"Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message news:95fb3eea42b9c@uwe...
I have a list of dates associated with Week Nbrs starting in column B, C & D.
Several formulas link to a summary table on another worksheet which counts
occurances for a particular week and several years. I have figured out how to
write an If statement using data validation so that the user can see a list
of dates associated with the weekly summary labeled "Week 1" but it requires
me to define names for each week. Example Name: Week_1_2009 = $B$4:$B$7 ect...
This list, below, goes on until the end of 2012.

I was hoping to be able to write a macro that will define all these names for
me without having to physically define each name....I don't know how to do
that....Can anyone help?

Calendar Date Year Week Nbr
1/1/2009 2009 1
1/2/2009 2009 1
1/3/2009 2009 1
1/4/2009 2009 1
1/5/2009 2009 2
1/6/2009 2009 2
1

--
Message posted via http://www.officekb.com