Returning a zero if there is no month given
=if(a1="",0,month(a1))
is one way
=if(isnumber(a1),month(a1),0)
is another.
spudsnruf wrote:
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
--
Dave Peterson
|