Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate number of weeks a variable spans in
Hello,
I want excel to calculate how many weeks it took to complete 1 task. For example, as shown in the example below computer shopping spanned over two weeks, whereas clothes shopping only spanned over 1. Does anyone have any suggestions? Week Date 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 Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you calculate the number of weeks on a month | Excel Discussion (Misc queries) | |||
Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
Calculate number of weeks between dates in Excel 2000 | Excel Discussion (Misc queries) | |||
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE . | Excel Worksheet Functions | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions |