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?
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.