Hi Brad:

Check out:

http://www.cpearson.com/excel/weeknum.htm
--
Gary's Student


"Brad Payne" wrote:

Cannot find a way to do this easily. But, is there a way through Excel a
Date into a Week Number? For example 01/05/2005 would be considered Week 2
or 01/15/2005 would be considered Week 3. I'm looking for a command or does
Excel have a command do perform this type of task. Trying to pull Weeks into
a Pivot Table. Right now individual dates are showing in the Pivot Table and
really need Weeks.

Look forward to your response and thanks in advance!
Brad Payne