| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Count
Hi,
=SUMPRODUCT(--(YEAR(A2:A65536)=YEAR(TODAY()))) Mike "Richard" wrote: Mike Thanks for the reply. I found the issue was that I had entered =sumproduct(--(year(a:a)=year(today()))) with there being a lable (column header) in cell a2. I kept getting a return of #NUM! Is there a way around the label issue. Richard "Mike H" wrote: Try =SUMPRODUCT(--(YEAR($A$1:$A$100)=YEAR(TODAY()))) Mike "Richard" wrote: I must be going senile, as I can usually crack these things, but I am having massive problems counting dates. In column A I have the date entered as follows: =TEXT(WORKDAY(A636,1),"dd-mmm-yy") I need to count every date where the year is equal to the current year. Please put me out of my misery and I apologise for such a dumb ass question. Richard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
| count the mean in few date but on de date it has various data | Excel Worksheet Functions | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
Threaded Mode
