Hi All,
Just started a new job and things have been going well until now. I been given an assignment in excel and cannot figure out how to do it. Up until now, I am a intermediate excel user, know the basic functions including pivot tables.
Here is what I am trying to do:
I have 3,650 records in an excel table. Each of the records represents a task to be completed starting 1/1/2018. 70 tasks will be completed per week.
1) I want to add a column that assigns a week# to each block of 70 records, (e.g., First 70 records all have week#1 associated with them, next 70 records all have week#2 associated, etc.)
2) Then I want to add another column that identifies the month and year for each of the records, based on the week assigned to that record.
3) Finally, how can the month assignment take into account that for a week that straddles two months, some of the 70 records will fall in one month and the remainder of the 70 records will fall in the next month (e.g., of the 70 records assigned to week 5, 40 of those records will be in January and the remaining 30 records will be in Feb.)
Any help will be VERY much appreciated. Thanks in advance.
Ann
Just started a new job and things have been going well until now. I been given an assignment in excel and cannot figure out how to do it. Up until now, I am a intermediate excel user, know the basic functions including pivot tables.
Here is what I am trying to do:
I have 3,650 records in an excel table. Each of the records represents a task to be completed starting 1/1/2018. 70 tasks will be completed per week.
1) I want to add a column that assigns a week# to each block of 70 records, (e.g., First 70 records all have week#1 associated with them, next 70 records all have week#2 associated, etc.)
2) Then I want to add another column that identifies the month and year for each of the records, based on the week assigned to that record.
3) Finally, how can the month assignment take into account that for a week that straddles two months, some of the 70 records will fall in one month and the remainder of the 70 records will fall in the next month (e.g., of the 70 records assigned to week 5, 40 of those records will be in January and the remaining 30 records will be in Feb.)
Any help will be VERY much appreciated. Thanks in advance.
Ann
