Aggregate Function

[Tikey]

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

 

[Tikey]

I had missed it.

An answer of 01/03 is acceptable. If a leap year does give an incorrect answer by a day, it will not be an issue in how I am using it.

Thanks again.

 

[Tikey]

I did miss it.

If leap years affect the answer by a day that will not be a problem.

Thanks again.

 

[jasonb75]

You're welcome!

Thanks for the feedback