I'm trying to develop a task management system where I need to check all the completed tasks for a given date.
Pls refer to the attached sheet.
When I check the box as complete (Column B), Column C automatically has to print the current date. For that I gave the equation: =if(B3=True,NOW(),"")
Each time a checkbox is checked, the date will be automatically added in column C.
But the real challenge is I also want to display the number of tasks I completed on a specific date in Column F. For that, I gave the equation: =COUNTIFs(B:B=true,C:C=E4)
But as you can see, the answer comes in zero. I even checked if the two dates are equal by checking: =if(E4=C4,True,False), and the answer came out False.
Although both the dates are equal, how come they are false? How can I solve this issue?
Aucun commentaire:
Enregistrer un commentaire