Hi, How can a range of cells that are dates be counted if the date in the cell is prior to today.
K Keith Jan 12, 2005 #1 Hi, How can a range of cells that are dates be counted if the date in the cell is prior to today.
P Peo Sjoblom Jan 12, 2005 #2 =COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
=COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
K Keith Jan 12, 2005 #3 Thanks! Peo Sjoblom said: =COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) Click to expand...
Thanks! Peo Sjoblom said: =COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) Click to expand...
K Keith Jan 12, 2005 #4 Thanks Peo Sjoblom said: =COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) Click to expand...
Thanks Peo Sjoblom said: =COUNTIF(Date_Range,"<"&TODAY()) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) Click to expand...
