Using MONTH formula with a blank date cell

edited 12/09/19 in Formulas and Functions

I have been using the month formula to create a month number from an 'Actual close date' column.

however i get error when the source column 'Actual close date' is blank

I can get the month number to work when dates are included with =MONTH([Actual Close date]4)

and I can clear away error message if source is blank with  =IFERROR([Actual Close date]18, "")

but no matter how many times I try to work this I can't get a combined formula a to work

IE: when there is a date deliver the month number and when there is no date leave blank ( or even a 0 would be ok i think)

hope someone can help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!