CODEWITHSUNDEEP
excel
John peter
John peter

Reputation: 154

Excel formula to show only months that have ended

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)

enter image description here

Upvotes: 0

Views: 85

Answers (2)

Ozan Sen
Ozan Sen

Reputation: 2615

The result set shows months blank which has not ended yet. enter image description here

Upvotes: 0

Solar Mike
Solar Mike

Reputation: 8375

Works as shown for me:

enter image description here

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

Upvotes: 1

Related Questions