Forum Discussion
Excel formula error
Please help! So this is my formula "=SUM(COUNTIFS(Feb!H2:H28,{"CHSP"},Feb!A2:A28,{">=03/02/2020"})-COUNTIF(Feb!A2:A28,">07/02/2020"))". Essentially I am trying to calculate whenever we enter CHSP wit...
the best ways to compare date values are
1. get the dates from a cell which is already given
2. use DATEVALUE to create a date number from given text.
Otherwise your comparison in the formula will return an error as you are comparing an actual date with a string.