Hi
I have a column of dates which cover several years in the format 01/01/2018, this column is modified with dates added to and removed regularly. I wish to be able to search for a particular year and then sum all the dates in that year without counting the same date twice.
I have been trying SUMPRODUCT without any success, can anyone offer any guidance please.
Thanks.
I have a column of dates which cover several years in the format 01/01/2018, this column is modified with dates added to and removed regularly. I wish to be able to search for a particular year and then sum all the dates in that year without counting the same date twice.
I have been trying SUMPRODUCT without any success, can anyone offer any guidance please.
Thanks.