LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 15th 16, 08:41 PM
Junior Member
First recorded activity by ExcelBanter: Apr 2016
Posts: 2
Default Productivity Statistics

I am using the following formula to calculate a statistic for employee #5274:

=COUNTIFS(July!$G$3:G120,5274,July!$I$3:I120,"8/1/2015")+COUNTIFS(August!$G$3:G120,5274,August!$I$3: I120,"8/1/2015")

Is there any way to make excel automatically change the date "8/1/2015" to the next sequential date "8/2/2015". I have tried to drag the formula from one cell to the next, but that just changes my ending ranges from G120 and I120 to G121 and I121 respectfully.

Any help on this would be appreciated.

Last edited by ANoline : April 15th 16 at 08:46 PM

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Productivity Log drew Excel Worksheet Functions 3 April 15th 16 08:54 PM
Productivity Michelle Excel Worksheet Functions 1 May 1st 08 07:59 PM
calculate a productivity percentage Dyson New Users to Excel 1 September 13th 07 08:46 AM
How do I make a productivity report? merniewlt Excel Worksheet Functions 0 May 23rd 06 02:46 PM
Quality/ Productivity diagram KrunoG Charts and Charting in Excel 2 January 31st 06 05:55 PM

All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017