Forum Discussion

Ahmad920's avatar
Ahmad920
Copper Contributor
Aug 06, 2020

Date function

Hello,   could you please help with the question in the file attached   thanks
excel
  • Ahmad920's avatar
    Ahmad920
    Copper Contributor
    Aug 06, 2020

    Thanks HansVogelaar 

    but when I use your formula I get  397  while there is only 7 dates in 2020

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 06, 2020

      Ahmad920 

      There are more blanks which are considered as open

      • Ahmad920's avatar
        Ahmad920
        Copper Contributor
        Aug 06, 2020

        Thanks SergeiBaklan  you are right

Resources