Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count how many weeks have the same value
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count how many weeks have the same value
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count weeks | New Users to Excel | |||
How do I count the number of even weeks in the current month. | Excel Worksheet Functions | |||
Working Weeks | Excel Worksheet Functions | |||
how to count weeks from date "X" then calculate | Excel Worksheet Functions | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions |