Count how many weeks have the same value

R

roniaelm

Hello,

I want excel to count how many weeks a task has been completed in.
I have set-up my spreadsheet as follows:

Week Week No. Day Date
15/10/2007 1 Monday 15/10/2007
 
R

roniaelm

Sorry to continue my question, I clicked on the wrong button I think

An example of how I have set-up my spreadsheet is as follows:

Week Week No. Day
Date Task
15/10/2007 1 Monday
15/10/2007 Computer shopping
1 Tuesday 16/10/2007
1 Wednesday 17/10/2007
1 Thursday 18/10/2007
Clothes shopping
1 Friday 19/10/2007
1 Saturday 20/10/2007
1 Sunday 21/10/2007
22/10/2007 2 Monday 22/10/2007
2 Tuesday 23/10/2007
2 Wednesday 24/10/2007
2 Thursday
25/10/2007 Computer shopping
2 Friday 26/10/2007
2 Saturday 27/10/2007
2 Sunday 28/10/2007

I want excel to calculate how many weeks it took to complete 1 task.
For example computer shopping spanned over two weeks, whereas clothes
shopping only spanned over 1. Does anyone have any suggestions?

Thanks for your help!
 

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

Similar Threads

using a time format in a count function 1
need help writing function 9
Count working days by week 7
Week count 2
Summing weekly values to fall into correct month 2
Group information from several worksheets into one worksheet 1
Display "this week" column headers w/date & day of week? 9
Selecting date range for counts 5

Top