Please help! I have a dataset with ID, hiredate, termdate for different offices and would like to get a breakdown by month and quarter. For example I want to know the total number of hires in jan, feb, mar and then cumulative for that quarter and then for all the offices, a breakdown of hires by month. I have sample data here. OFFICES EmployeeID Hiredate Termdate DC office 1001 01022013 04302013 DC office 1002 12012013 04302014 DC office 1003 02152013 03302014 DC office 1004 04162013 08202013 DC office 1005 01022013 04302014 DC office 1006 12012013 03302014 DC office 1007 03162013 08202013 DC office 1008 01022013 04302013 VT office 1015 02152013 01302014 VT office 1016 04162013 00302014 VT office 1017 01022013 05082014 VT office 1023 03162013 04302014 VT office 1024 01022013 03302014 VT office 1025 12012013 08202013 TN office 1026 02152013 01052014 TN office 1027 04162013 04302013 TN office 1028 01022013 05182014 TN office 1029 12012013 03302014 TN office 1030 03162013 08202013
... View more