FORMAT and IF Statement

[lian96022]

I have a Column that formats another Column with a date into "mmm-yyyy". However, if the cell is empty I would like it would place the text "Open" in the field. Currently I have Column = FORMAT(Sheet1[Closed],"mmm-yyyy")

Any suggestions...

[JIGAR · Accepted solution]

@lian96022 

You can create a new column using this formula.

NewDateColumn = if(ISBLANK(Sheet2[ENDTIME]),"Open",FORMAT(Sheet2[ENDTIME],"mmm-yyyy"))

Hope this helps !!

Please mark it as accepted if the solution was appropriate.

Thanks

[lian96022]

Thanks! that worked.