Hi,

My excel does not recognise a standard function such as
=sumif(a1:a10,month(a10),b1:b10) or =eomonth(a1), whereby column A contains
dates and column b numbers.

Please help.

Thanks,
Loan