Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Basically I have 2 columns each with a list of dates in no particular order (and containing blank cells too), one planned date column and one actual date column. What I need to do is plot this on a graph, and since the number of dates has no set limit and I dont want to have to plot maybe 100 dates on the x axis, so i want to group them by week before plotting them, i.e. 10 dates for week ending 10th jan, 25 dates for week ending 17th jan etc I have a pivot table that counts how many of each date occurs, i.e. 10 x 2nd jan, 7x 3rd jan etc etc but it does not split them into weeks. im sure theres an easyish way of doing it so i can get the 2 lines on the graph for no. of planned dates each week and no. of actual dates each week, i just cant see it. thanks -- neowok ------------------------------------------------------------------------ neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940 View this thread: http://www.excelforum.com/showthread...hreadid=505716 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
count date occurances in range of dates... | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions | |||
have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
I have a list of dates that I need to count based on a date range | Excel Worksheet Functions |