How would you go about using sumif with dates like this - I would usually sumif dates in a month using <= and >= dates, but these dates with times are not integers so get missed - I am currently using a helper column with =INT() but wondered if I could do away with that somehow?;
20/05/2021 12:03 |
20/05/2021 12:03 |
25/05/2021 09:29 |
25/05/2021 09:29 |
09/04/2021 |
09/04/2021 |
09/04/2021 |
09/04/2021 |
09/04/2021 |
09/04/2021 |
10/05/2021 |
10/05/2021 |
15/04/2021 09:12 |
15/04/2021 09:12 |
15/04/2021 09:12 |
15/04/2021 09:12 |
15/04/2021 11:07 |
15/04/2021 11:07 |
16/04/2021 11:19 |
16/04/2021 11:19 |
16/04/2021 11:19 |
02/04/2021 |
02/04/2021 |
02/04/2021 |
07/04/2021 |
07/04/2021 |
13/04/2021 |
13/04/2021 |