Forum Discussion
Solved
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 formu...
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.
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.
Thank you so much! It helped