| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the number of dates less than a given date
I'm trying to count the number of dates with a range of dates that are iether
less than or greater than a give date (e.g. Today () function) E.g. 10/08/09, 11/08/09, 12/08/09, 13/08/09. Today's date is the 12/08/09 the result would be 2 (10 & 11/08/09) less than the 12/08/09 and 1 (13/08/09) greater than. Is there a function to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count the number of dates less than a given date
Assuming your data is in column A
Less than today: =COUNTIF(A:A,"<"&TODAY()) Greater than today: =COUNTIF(A:A,""&TODAY()) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mickblackburn2" wrote: I'm trying to count the number of dates with a range of dates that are iether less than or greater than a give date (e.g. Today () function) E.g. 10/08/09, 11/08/09, 12/08/09, 13/08/09. Today's date is the 12/08/09 the result would be 2 (10 & 11/08/09) less than the 12/08/09 and 1 (13/08/09) greater than. Is there a function to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| In a set of dates, can you count the number of Jan '07 instances? | Excel Worksheet Functions | |||
| Count number of dates | Excel Worksheet Functions | |||
| Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
| How do i count number of weekdays between two dates? | Excel Worksheet Functions | |||
Linear Mode
