Forum Discussion
Solved
COUNTIF Containing Date Calculations
Hi Everyone! I hope someone can help me here. I'm working in a Table where I am tracking maintenance on my boat. File attached. I have a Date Due column and a Date Completed column. I display the ...
You may use below formula in cell B9
=COUNTIFS(Table110[Date Due],"<="&TODAY(),Table110[Date Completed],"")
Thanks
Tauqeer
Hi Tauqeer.
It works great! Thank you. What does the "10" you placed after "Table1" do and where can I find a good reference on using it?
Thanks again,
George
It works great! Thank you. What does the "10" you placed after "Table1" do and where can I find a good reference on using it?
Thanks again,
George
You are welcome.
I have not placed '10' rather its the part of table name in your file. Please see the below image. Same table name "Table110" is appearing in your formula as well.
Thanks,
Tauqeer
- I see that. For some reason I thought I was working with Table 1. I like the simple code you used. I believe I had tried something similar but didn't have the "" in the criteria at the end. Thanks again. I've been struggling with this for 2 days!
Regards,
George