Ask Your Question

How to get a date from text? [closed]

asked 2017-01-12 09:15:53 +0200

Aigars gravatar image

Hi! I have spreadsheet that has one cell where the user has to input a year number, like "2016" and it's used for titles (text) on other sheets. Now I need to get a date from this year number. I.e. if the user inputs "2016" I need to get a date 01.01.2016, if the user inputs "2017", I need to get 01.01.2017. Its necessary for further calculations. Any ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Aigars
close date 2017-02-01 15:48:04.863127

1 Answer

Sort by » oldest newest most voted

answered 2017-01-12 09:23:57 +0200

Aigars gravatar image

Thanks, I found the answer myself. It was really easy actually. LOL DATE(F16;1;1), where F16 is the year number the user inputs and first number one is the month and the second number one is the day. And the result is 01.01.2016.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-01-12 09:15:53 +0200

Seen: 66 times

Last updated: Jan 12 '17