Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif a date is greater than today
Hi,
How can a range of cells that are dates be counted if the date in the cell is prior to today. -- Keith |
#2
|
|||
|
|||
=COUNTIF(Date_Range,"<"&TODAY())
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Keith" wrote in message ... Hi, How can a range of cells that are dates be counted if the date in the cell is prior to today. -- Keith |
#3
|
|||
|
|||
Thanks!
"Peo Sjoblom" wrote in message ... =COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Keith" wrote in message ... Hi, How can a range of cells that are dates be counted if the date in the cell is prior to today. -- Keith |
#4
|
|||
|
|||
Thanks
"Peo Sjoblom" wrote in message ... =COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Keith" wrote in message ... Hi, How can a range of cells that are dates be counted if the date in the cell is prior to today. -- Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
Today() or Date() function help | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Show a date based on today | Excel Worksheet Functions |