Sep 22 2019 04:00 PM
Hi everyone. Can you please help me to solve my problem. I have series of joined data in Year column with year-month separated by "-". What I want is to separate dates for From Year and To Year. I tried to use Left function =LEFT(H2,LEN(H2)-SEARCH("-",H2)). However, how do I go about if there is only starting date available in Year column (for example 14.4-). Once I use Left function, it gives me a blank result.
Another question is how do I convert that date into full date (for example 14.4 into 2014.04 or 99.9 into 1999.09)?
Your help is appreciated!!!!
Sep 22 2019 04:41 PM
SolutionSep 22 2019 06:28 PM
Sep 23 2019 03:53 PM
Hi Wyn,
As a comment, I'd modify a bit like
=IFERROR(DATE(2000-100*INT(L3/50)+L3,M3,1),"")
to avoid locale dependency and handle missing of period end.
Sep 22 2019 04:41 PM
Solution