Should be possible using built-in functions...

C

cmalmqui

I am currently writing on a worksheet breaking down my project work
into days worked per month. (I am usually on 3 to 6 week long
projects...)

Input is therefore along these lines:

ID, Start Date, End Date
A , 16/10/2005, 20/11/2005
B , 20/01/2006, 25/01/2006
C , 30/01/2006, 03/03/2006

I have been trying using the function SUMPRODUCT as a basis to create
the following:

Period , Workdays
Oct/2005, 15
Nov/2005, 20
Dec/2005, 0
Jan/2006, 6
Feb/2006, 28
Mar/2006, 3

But I am getting nowhere...
Any ideas on how to solve using built-in functions?
(Need a kick in the right direction from the pro's!)

Regards,
Christian
 

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

Should be possible using built-in functions... 1
How to getting text labels to show up in scatter chart. 0
Problem formatting dates from CSV file 2
I need to help with Excel (beginner) -- year row and month column 2
Column Headings Repeating 5
2 dimensional date sort 2
Date Sorting 2
Date Sorting 2

Top