Returning a zero if there is no month given

[spudsnruf]

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]

=if(a1="",0,month(a1))
is one way

=if(isnumber(a1),month(a1),0)
is another.

 

[spudsnruf]

=if(a1="",0,month(a1))
is one way

=if(isnumber(a1),month(a1),0)
is another.

 

[spudsnruf]

Perfect. Thank you very much.

=if(a1="",0,month(a1))
is one way

=if(isnumber(a1),month(a1),0)
is another.