View Single Post
  #1   Report Post  
Brad Payne
 
Posts: n/a
Default Date Range -- Weekly

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