rexceldatedate-formatyearmonth

Transform an input with "month year" to "month/year" in R

If a time-related information is read as "Jun 2008". Are there any convenient approaches to transform it into date format in R or Excel, i.e., 06/2008?

Solution

  • In Excel the following formula will do the trick:

    =TEXT(A1,"mm/yyyy")