Forum Discussion

Copper Contributor

Mar 08, 2021

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 ...

TEST.xlsx16 KB

Formulas and Functions

tauqeeracma
Mar 08, 2021
Hi George_Weston

You may use below formula in cell B9
=COUNTIFS(Table110[Date Due],"<="&TODAY(),Table110[Date Completed],"")

Thanks
Tauqeer

tauqeeracma

Iron Contributor

Mar 08, 2021

Hi George_Weston

You may use below formula in cell B9

=COUNTIFS(Table110[Date Due],"<="&TODAY(),Table110[Date Completed],"")

Thanks

Tauqeer

George_Weston
Copper Contributor
Mar 08, 2021
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
- tauqeeracma
  Iron Contributor
  Mar 08, 2021
  Hi George_Weston
  
  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
  - George_Weston
    Copper Contributor
    Mar 08, 2021
    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