My data looks like this - I want to sumifs using the data, but it doesn't pick up the ones with time as they aren't integers.
I could of course change the source data but I'm trying to automate a process so would prefer a formula to deal with it - so in the example below sumifs should treat the first 2 as the same date;
Any help would be greatly appreciated!
I could of course change the source data but I'm trying to automate a process so would prefer a formula to deal with it - so in the example below sumifs should treat the first 2 as the same date;
Any help would be greatly appreciated!
07/08/2023 12:56 |
07/08/2023 |
23/09/2022 08:46 |
23/09/2022 |