| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs and wildcards to count dates
Hi!
I have a countifs functions which has, among other criteria, to count all the dates of a certain month and year. here the formula: =countifs(...;[range];"=*"&month(A4)&"/"&year(A4);...) this formula returns 0. If I change the wildcard with a specific day number, it works fine. Any clue? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to use wildcards for dates? | Excel Discussion (Misc queries) | |||
| COUNTIFS - 2 different scenarios to count | Excel Discussion (Misc queries) | |||
| countifs with multiple dates | Excel Worksheet Functions | |||
| Countifs -Count no of times products have been sold on particular | Excel Worksheet Functions | |||
| countifs Text and Dates | Excel Worksheet Functions | |||
Threaded Mode
