Excel formula for blank cell

[Sivas]

Need a help on Excel Formula.

I have 2 columns, Column A & Column B.

Column A has date in it as 3/5/2019. if there is date, Column B should return as 05-Mar. If Column A is blank, Column B should be blank.

I have a formula as

=IF(ISBLANK(A10)," ",IF(A10="Yes","No"))

but it is not giving correct answer. Can anyone help on this formula.

<tbody>
</tbody>

 

[steve the fish]

Presuming its just formatting in column B that changes the look of the date its:

=IF(A10="","",A10)

 

[Sivas]

Thank you for the reply.

But if Column A is blank, the column B is not getting blank.

 

[tyija1995]

Try this in B10:

=IF(ISBLANK(A10),"",A10)

Then format B10 in dd-mmm format

 

[steve the fish]

Thank you for the reply.

But if Column A is blank, the column B is not getting blank.

What does that mean? What is in A10 and what is the formula producing?

 

[pedro-egoli]

What is cell A10 with the date 3/5/2019 formatted as?
In Australia that date is equivalent of 3rd of May .
You probably need to play around with custom formatting.

 

[pedro-egoli]

I have assumed your exercise is in cells A10 and B10.

Excel Workbook
	A	B
10	3/05/2019	3-May
Sheet1

A10 is formatted simply as DATE
B10 is custom formatted as d/mmm