Hi, I have a table of data (Jul-Feb) I would like to calculate for each day my workload:
Project No. Start Date End Date
1 01/07/15 04/07/15
2 01/07/15 03/07/15
3 01/07/15 06/07/15
4 02/07/15 06/07/15
what I would get to get as a result is
Date Projects
01/07/15 3
02/07/15 4
03/07/15 4
04/07/15 3
05/07/15 2
06/07/15 2
07/07/15 0
Any help would be appreciated!!