Forum Discussion

Юлия Ермилова's avatar
Юлия Ермилова
Copper Contributor
May 15, 2018

Problem with formulas and dates

I have problems with counting cells on list "28 days".

Initially i can choose a date on the list Report at B3 and C3 cells and formulas on the "Formulas" list will count the number of cells by formula =COUNTIFS('28 days'!A2:A950;">="&B3;'28 days'!A2:A950;"<="&B4;'28 days'!D2:D950;"=OPP")

 

The problem is that its not counting the cells with date 14 of May for some reason and its not showing any data when I choose date from 14.05.2018 to 14.05.2018 though it should as I use ">=".

 

Really would appreciate your help!

Formulas & Functions
Show and Tell
  • Detlef_Lewin's avatar
    Detlef_Lewin
    May 15, 2018

    Hi

     

    the dates in sheet 28 days column A are not dates but time stamps. They contain a time part. If you try to count from 14.05.18 00:00 to 14.05.18 00:00 there will no match.

    Either remove the time component in sheet 28 days or add a time component in sheet report.

     

     

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    May 15, 2018

    Hi

     

    the dates in sheet 28 days column A are not dates but time stamps. They contain a time part. If you try to count from 14.05.18 00:00 to 14.05.18 00:00 there will no match.

    Either remove the time component in sheet 28 days or add a time component in sheet report.

     

     

Resources