Return the month of a closed item

Stephen Halsey

Hi,

I'm trying to create a formula for when a query is closed and the month is return in a separate column. I have managed to complete this for the month the query is opened as all items opened have such a date. However, if the query is not closed the cell is blank and I receive the following error message "#INVALID DATA TYPE"

Thanks,

Steve

Frank S.

Greetings @Stephen Halsey,

If you already have a formula that works, except when the reference cell is blank, you can add the following to the formula:

=IFERROR((Your formula), "")

This will leave the cell blank if the formula returns any errors.