# 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