Converting partial text date to numeric value date

[snezana]

I want to calculate the ages of the people in a data set.
Unfortunately, their birth dates are plain text values, "1 August 2000".
I've tried a bunch of things, but can't work it out. I want to convert the values from "1 August 2000" to its numerical equivalent, like "1/8/2000".
So that I can use that to calculate the age based on this birth date (I tried doing it with the text value I have, using TRUNC(YEARFRAC but ofc since it's basically plain text it doesn't return any value).
The extra challenge I have is that I work with English languaged excel, and the months are in Dutch (so augustus instead of august), which probably adds another layer of complexity :')
Anyone have any good ideas?

 

[Muhammad_Usman]

1235.xlsm
	C	D
1	1 August 2000	01-08-2000
Sheet23

Cell Formulas
Range	Formula
D1	D1	=TEXT(C1,"DD-MM-YYYY")

 

[eiloken]

you can change cells format to custom with "d/m/yyyy" type

 

[SanjayGMusafir]

1. Convert the column to date or number - This will help you identify which cells still have problem
2. Select entire column and use find and replace
   1. " augustus " to "/"
   2. Obviously you have to do 12 Find and Replace - 1 for each month

I believe that should work for you

 

[awoohaw]

If the cell is indeed a text and not a date:

what version o excel are you using.
for 365 versions:
=date(
1*textafter(A1," ",2),
XMATCH(textafter(textbefore(A2," ",2)," ") ,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),
1*textbefore(A2," "))

for non 365 versions you can use other ways to figure out the components.

 

[Georgiboy]

Which version of excel are you using?

 

[snezana]

Thanks all, several good solutions! I have it solved! You made my day

 

[snezana]

1235.xlsm
	C	D
1	1 August 2000	01-08-2000
Sheet23

Cell Formulas
Range	Formula
D1	D1	=TEXT(C1,"DD-MM-YYYY")

I switched to an online version of excel where i could work in Dutch, used the Dutch version of this formula and it worked