Change Accounting Period 005/2019 to proper date

0

Hi Everyone,

Just would like to find out whether there is any formulat can help me to change accounting period to proper date? E.g 005/2019 change to 01/05/2019.

Thanks

Answer
Discuss

Discussion

Please don't forget to select the answer that worked for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1745) Aug 20, '19 at 2:35 pm
Add to Discussion

Answers

1

If not a date already, and A2 is the string value, B2=DATE(RIGHT(A2,4),LEFT(A2,3),1)

Then, manually set date formate for column B.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login