Forum Discussion
Solved
How to count cells based on date and if not empty
If anyone could help me I have an excel spreadsheet where the top row are dates and the first column has different tasks. Below each date there is data to mark if something was done or not on each da...
=COUNTIFS(C2:L2,"<>",$C$1:$L$1,"<"&TODAY())
=COUNTIFS(C2:L2,"<>",$C$1:$L$1,"<"&TODAY())
Thanks a lot, been trying to solve this for a while now. THANKS!