| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do a count dates?
=COUNTIF(Range,"<"&TODAY())
replace TODAY with NOW if you want to compare time as well as dates Regards, Peo Sjoblom "Aviator" wrote: In a specific cell, I am wanting to count a series of dates with each date less than NOW() to be worth +1 and each date equal to or more than NOW() to be worth 0. Thank you, Aviator |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
| Dates Subtracting dates. | Excel Discussion (Misc queries) | |||
| Can I get email alerts when dates in excel are nearing? | Excel Discussion (Misc queries) | |||
| Dates | Excel Discussion (Misc queries) | |||
| filter and count | Excel Discussion (Misc queries) | |||
Linear Mode
