I am using Excel 2019, not 365
I have a list of dates which cover several years in the format 31/01/2020, some of the date cells contain errors ie #NUM!. I am trying to find the average of the dates, but excluding the year ( day & month only ) and I also do not wish to create any new cells when doing this.
I have been trying to do this using the aggregate function, but cannot find a way of excluding the year.
Maybe there is a better function, can anyone help.
Thanks
I have a list of dates which cover several years in the format 31/01/2020, some of the date cells contain errors ie #NUM!. I am trying to find the average of the dates, but excluding the year ( day & month only ) and I also do not wish to create any new cells when doing this.
I have been trying to do this using the aggregate function, but cannot find a way of excluding the year.
Maybe there is a better function, can anyone help.
Thanks