Get instant live expert help on I need help with calendar 2016 with week numbers

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I need help with my pivot table. My table is totaling the number of hours worked per week and the total cost. However, I can not figure out how to also get a total for the number of week each employee worked. Can you help Row Labels Sum of Cost Sum of Actual Hours Adrienne Avery $26,458.82 489 8/16/2016 - 8/22/2016 $25.00 0.5 8/23/2016 - 8/29/2016 $92.50 1.5 8/30/2016 - 9/5/2016 $202.50 3 9/6/2016 - 9/12/2016 $352.50 6 9/13/2016 - 9/19/2016 $185.00 3 9/20/2016 - 9/26/2016 $160.00 2.5 9/27/2016 - 10/3/2016 $242.50 4.5 10/4/2016 - 10/10/2016 $451.25 6.5 10/11/2016 - 10/17/2016 $345.00 5.5 10/18/2016 - 10/24/2016 $497.50 14 10/25/2016 - 10/31/2016 $540.00 18
Solved by M. A. in 27 mins
how do I combine multiple dates in one column with associated sales numbers in another so I can get daily sales totals as one number (not 15 individual transactions? 07/13/2016 31.93 07/13/2016 53.77 07/13/2016 291.73 07/13/2016 45.89 07/14/2016 46.35 07/14/2016 0.01 07/14/2016 2,024.11 07/14/2016 325.00 07/14/2016 24.98
Solved by A. H. in 28 mins
I had help yesterday in setting up a formula to auto fill blocks based on a cell with a date & a cell with an amount of days. This formula is perfect, but for me, it has one issue. My team calendar & project calendar only has week days. Is there a way to tweek the formula to take this into account?
Solved by S. U. in 20 mins
I made a schedule on a worksheet that has names of workers across the top, then under their names has their work times for a two week period (1 pay period). I want to pull each row of that information to a calendar so if employee "a" "c" and "f" is working it adds their name to a calendar coinciding with that date with their time in and time out. So when I look at the calendar it says on this day these three people are working with their assigned times.
Solved by G. A. in 30 mins
I know how to make a forumal change weekly with fixed numbers but how do you make it change with numbers that change weekly? For example: =8*'sheetname'!$A$1 What if the 8 wasn't the same every week?
Solved by Z. U. in 13 mins