Forum Discussion
if the date column is NA or 0 how to show 0 in the auto formula?
hi I have a date column and there are some row that will have not date in it. I want to auto pick the date into MONTH in numbers with the formuala =MONTH(date col) but how to show empty or 0...
To throw another option into the mix, a valid date will be a positive number. Hence
= IF(ISNUMBER(date), MONTH(date), "")works in most instances. and
= IF(ISNUMBER(date)*(date>0), MONTH(date),"")would also pick up zeros.
Note: I have used the name 'date' for an array of one or more possible dates.