| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
New Member
Join Date: Apr 2011
Posts: 3
|
 I would like to countifs "(e5:ne5,"s")" and "countifs only those from the past 30 days at any given time based on a row of dates that are at the top of the spread sheet i feel that somewhere in there i need to refur to $E$4:$NE$4 as the reference because those cells contain the dates 1/1/11 thru 12/31/11 i just dont know how or where =COUNTIFS(E5:NE5,"="&EDATE(TODAY(),1)-30,E5:NE5,"s") |
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| countifs with multiple dates | majestyk | Microsoft Excel Worksheet Functions | 2 | 10th Feb 2009 07:31 PM |
| countifs Text and Dates | mokihi | Microsoft Excel Worksheet Functions | 7 | 4th Sep 2008 05:30 AM |
| Calc days between two dates and exclude leap year days | scoz | Microsoft Excel Worksheet Functions | 5 | 23rd Nov 2007 03:58 PM |
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Sioux | Microsoft Excel Worksheet Functions | 2 | 11th Oct 2007 02:04 PM |
| Determine dates by number of days, "what date is 180 days from now | =?Utf-8?B?VFJMYW1i?= | Microsoft Outlook Calendar | 2 | 19th Apr 2007 03:30 PM |
