I would like excel to show only the months that have ended. For the months that have not ended, I want the cells to be blank. I used this formula and it shows up #VALUE!. How do I fix this?

=IF( OR( IFERROR( (EOMONTH(A343,0) 1 > EOMONTH(TODAY(), -1)), ""), ISBLANK(A343) ), "", EOMONTH(A343,0) 1)

CodePudding user response：

Works as shown for me:

The formula you gave results in a blank as the month has not ended yet, while April has ended.

CodePudding user response：

The result set shows months blank which has not ended yet.