import the days have not passed the today

manos

New member
Joined
Nov 12, 2012
Messages
13
Reaction score
0
Points
0
import the days have not passed the today
 

Attachments

  • day.xls
    26 KB · Views: 19

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
2010
Hi Manos
If I understand you correctly your wanting to count for each person how many dates are before today (eg how many tasks haven't completed by the due date).

If so then this formula will do that:
=COUNTIFS(Φύλλο1!$A$2:$A$16,A2,Φύλλο1!$B$2:$B$16,"<"&$D$1)
Enter this in Sheet2 cell A2, and drag down. As it stands, if the date = TODAY() then it won't be counted.

HTH
Hercules

 
Top