bencar
Banned user
- Joined
- Jun 8, 2016
- Messages
- 149
Hi guys,
I'm using a DATE function to format a date to MM/DD/YEAR. I want to format 31.3.14 to 3/31/2014. I used this formula:
=DATE(2000+RIGHT(C12,2),MID(C12,3,2),LEFT(C12,2))
But it results in: 12/31/2013. Why is this happening? I'm doing everything correct!
I'm using a DATE function to format a date to MM/DD/YEAR. I want to format 31.3.14 to 3/31/2014. I used this formula:
=DATE(2000+RIGHT(C12,2),MID(C12,3,2),LEFT(C12,2))
But it results in: 12/31/2013. Why is this happening? I'm doing everything correct!
Last edited: