I have a report with date, text & time with timezone in a cell and the requirement is to sort this in ascending order. I have tried to use delimiter, concatenate and also convert text to date but the "at" in between date & time is giving me issues and i am having a tough time ...
Also, I need to calculate the age of a person and I use =datedif(xx,xx,"y"). But, again,. the calculation won't work for any date prior to 1900. Is there a fix for both the formatting issue and the calculation? Thanks in advance for your help. Reply Alexander Trifuntov (Ableb...