Excel Formula not working my way

[nguyenvkevin]

ey Everyone,

Can you make this "False /True" go blank cause it still shows false and or true? I want to place the cell 1 formula and when it is the beginning of the month then it will say ex. June 2019 until then will stay invisible. Any suggestions is highly recommended>.

I'm also looking to use "MMMM YYYY" but unsure where it would go in this instance?

CELL1: =IFERROR(Table!E2=1,DATE(YEAR(Table!D2),MONTH(Table!D2),Table!E2))
CELL2: 6/1/2019
CELL3: =DAY(CELL2)

Thank You,
K

[63falcondude]

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

[Fluff13]

Maybe

Please Login or Register  to view this content.

or just

Please Login or Register  to view this content.

& format the cell as MMMM YYYY

[jeffreybrown]

Hi nguyenvkevin,

Administrative Note:

Welcome to the forum.

We would love to help you with your query; however, the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)