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!
  - Lorenzo
    Silver Contributor
    Dec 27, 2022
    You're welcome, glad I could help
    There's a mark as solution link at the bottom of each reply you get - This helps those who search
    Thanks & Nice day...