| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF for numbers of dates in column which are 30 days older than today
I have a column with dates. I need a count of how many of these date
are older than today's date. I tried: =COUNTIF(L7:L155,"-(=TODAY())30") and it returns 0 Anyone able to help here, please? Thanks Jonathan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply green to current date, red to 2 days overdue and none if pai | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| How do I add a range by date over 90 days older than today | Excel Discussion (Misc queries) | |||
| counting dates in a column that less than 6 months from today | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Threaded Mode
