Hello,

I have a simple equation to just return a value for the month that a payment
was received.

=month(a1)

at the moment, where there is no date in a column, i seem to be still
getting a value of 1. What i need to do is to return a value of 0 if there is
no date of payment.

Thanks very much