How two extract text behind last dash"-" from multiple dash "-" containing text?

How two extract text behind last dash"-" from multiple dash "-" containing text?
-
For example the text is like as "2015-1-12", "2017-12-6" etc.
-
How to extract day value from above by same formula in excel.

If all of your text contains two dashes, you could use this formula

Formula:

Please Login or Register  to view this content.

Otherwise it will have to be edited based on how varied your data is

@nabinprd1,

why have you started a new thread? Read about the forum's approach to Duplicate threads in the Forum Rules (05) at the top of the screen

Continue in your other thread, where you already have two replies.

Pete

Thanks danielexcelvba, your ida is working.

yes Pete_UK bro you are talking true, this situation is done by unknown mistake, how to delete this thread?