| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting columns of dates
Because Excel translates dates to numbers, this is a difficult task. You can try something like: =SUMPRODUCT(--(A1:D1=DATE(2005,1,1)),--(A1:D1<=DATE(2005,12,31))) you can change the dates to what would be the earliest possible date and the latest possible date. Note that the dates are translated as 5 digit numbers. So Jan 1, 2005 is equivalent to 38353 and Dec 1, 2005 is 38691 so as long as you don't have numeric values within that range, the formula will count dates only. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=492293 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| counting dates | New Users to Excel | |||
| How to Calculate Dates without counting the weekends | Excel Worksheet Functions | |||
| counting in one column when two expressions in two other columns are true | Excel Worksheet Functions | |||
| counting entries between two dates? | Excel Worksheet Functions | |||
Threaded Mode
