Forum Discussion
Formula to insert date (with format) if cell isnt blank
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 w...
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