Forum Discussion

prometheis's avatar
prometheis
Copper Contributor
May 20, 2021
Solved

Excel help

Have a fairly simple request, i have a row of cells with dates, i tried using the countif function to tell me how many fit into a certain date but i have to put in the date every time, i want to use ...
  • HansVogelaar's avatar
    May 20, 2021

    prometheis 

    Use

     

    =COUNTIF(Q2:Q599, "<"&TODAY())

     

    or

     

    =COUNTIF(Q2:Q599, "<"&Q606)

Resources