K Kanisios Joined Jun 23, 2016 Messages 2 Reaction score 0 Jun 23, 2016 #1 How do I convert decimal year (e.g. 2014.48493) to date format (e.g. 26/06/2014) in excel? Please help me with the formula.
How do I convert decimal year (e.g. 2014.48493) to date format (e.g. 26/06/2014) in excel? Please help me with the formula.
muckshifter I'm not weird, I'm a limited edition. Moderator Joined Mar 5, 2002 Messages 25,751 Reaction score 1,210 Jun 23, 2016 #2 Try ... http://www.mrexcel.com/forum/excel-questions/569750-decimal-year-date-formula.html
K Kanisios Joined Jun 23, 2016 Messages 2 Reaction score 0 Jun 23, 2016 #3 Thanks for your response. I tried it before and it did not work. Or maybe I need to change the language of my computer, as I am currently using a german computer?
Thanks for your response. I tried it before and it did not work. Or maybe I need to change the language of my computer, as I am currently using a german computer?