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
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
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.