Forum Discussion

Copper Contributor

Dec 27, 2022

Solved

Why do I have to hit enter for format to work?

Okay so I remember having this question back in college, but never actually had the interest to google this question. So I have the following data (non-table), And in order for the Date format to ...

excel

Formulas and Functions

Albertoalej
Dec 27, 2022
Lorenzo

Didn't work, even when formatting as Date

Lorenzo

Silver Contributor

Dec 27, 2022

Albertoalej

Try the following in E2 and format the cell as Date:

=DATEVALUE(CONCAT("01","-",B2,"-",A2))

Albertoalej
Copper Contributor
Dec 27, 2022
Lorenzo

Didn't work, even when formatting as Date
- Lorenzo
  Silver Contributor
  Dec 27, 2022
  Albertoalej
  
  In column B:
  could you replace Januay with January and see how it goes...?
  - Albertoalej
    Copper Contributor
    Dec 27, 2022
    omg, I had already done the manual approach so I had to recreate the excel sheet just to try your approach and missed that letter. Did It this way and It now works, thanks a lot!