View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Helen Helen is offline
external usenet poster
 
Posts: 1
Default changing dates into months

Hi,
I have the following problem:

I'm exporting some timesheet data from SharePoint into Excel 2007.

It's in the following format:

Project
Name
date (e.g.: 10.02.2008)
hours worked

And so on.

I can easily export this into Excel 2007.

However, I want to build reports that group the timesheet entries
according to weeks and months.

Now i just have a big list of dates. I want to have Months, and within
that weeks.

Anyone got any tips on how to achieve this?

Thanks in advance!
Helen