Formula to insert date (with format) if cell isnt blank

[Barking_Mad]

I'm using the below formula to change the date format in an Sharepoiont List.

=TEXT(Leaving Date,"dd mm yyyy")

However it's returning a date value when the DOB cell isn't blank. I've tried to work in ISBLANK as below, but my brain cant get round the syntax. Can anyone help?

=IF(TEXT(ISBLANK([Leaving Date]),"",[Leaving Date],""dd mmm yy")

[#2]

@Barking_Mad Use formula like this: 

=IF(ISBLANK([Leaving Date]),"",TEXT([Leaving Date],""dd mmm yy"))

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

[#3]

Hi @Barking_Mad, did you try formula given in my answer above? Is it working for you? Let me know if you still need any help with this.

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs