Ask Your Question

(SOLVED) Convert text (2. October 1928) to data [closed]

asked 2018-04-25 09:11:35 +0100

T-buch gravatar image

updated 2018-04-25 12:35:08 +0100

I got two columns: 1st column contains a start-date and second column contains an end-date of a period. in the third column I would like to calculate the period in months.

The dates in the first and second columns are plain text such as 1st column: "2. October 1928" and second column: "7. June 1930" (Note the sentence).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-04-26 13:12:28.365735


As for me you not need convert this plain text to any other formats - function =DATEDIF(A1;B1;"m") must work properly with this values. With your examples of dates I has get 20 month - is it correct?

JohnSUN gravatar imageJohnSUN ( 2018-04-25 10:02:26 +0100 )edit

Thanks but I onlu got "#VALUE!"

T-buch gravatar imageT-buch ( 2018-04-25 10:31:01 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-04-25 10:04:16 +0100

m.a.riosv gravatar image

With Menu/Data/Text to column they can be converted on true dates for the spreadsheet, clicking on the column head an selecting the column type as DMY.

image description

edit flag offensive delete link more


Thanks but for me - in my calc, the "column type" is greyed out/ not available

T-buch gravatar imageT-buch ( 2018-04-25 10:54:14 +0100 )edit

Perhaps you have selected more than one column or have not selected anything.Try again - select single column and go to menu Data

JohnSUN gravatar imageJohnSUN ( 2018-04-25 11:20:20 +0100 )edit

I found out that I also have to select the column in the dialog box (even though I already did that in the first place in the spreadsheet) - so now it works, thanks

T-buch gravatar imageT-buch ( 2018-04-25 11:50:09 +0100 )edit

answered 2018-04-25 10:40:26 +0100

T-buch gravatar image

updated 2018-04-25 10:40:43 +0100

for me in my calc, the "column type" is greyed out/ not available

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-04-25 09:11:35 +0100

Seen: 35 times

Last updated: Apr 25 '18