|
|
|
|
#1
08-08-2012, 07:10 AM
|
|||
|
|||
they are dates
|
|
#2
08-08-2012, 07:20 AM
|
||||
|
||||
|
Okay, your original example had month and year numbers in separate cells. If you want to reference a single column which contains dates then a different formula is required. Here's one variation:
Code:
=AVERAGEIFS(SUPPORT!K9:K258,
SUPPORT!J9:J258,">="&EOMONTH(TODAY(),-1)+1,
SUPPORT!J9:J258,"<"&EOMONTH(TODAY(),0)+1)
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change Resource Time vs. Duration when Updating Work column | lylel | Project | 3 | 07-23-2012 06:09 PM |
| Displaying Work Week instead of date in a column. | whitney07 | Project | 1 | 07-05-2012 02:27 PM |
 definition of work column
|
ketanco | Project | 9 | 05-31-2012 05:15 PM |
|
Right-Aligning Data to a Column
|
sunnyside | Excel | 3 | 02-27-2012 01:25 AM |
| Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |
Windows XP 
Office 2010 32bit
Hybrid Mode