February 9, 2018
I need urgent help on the attachment file. I want to calculate the date and week from date time column. I have applied =DATEVALUE(TEXT(D102,"DD/MM/YY")) but few column giving me the error. I check also the formate of date time column I has two formats but I am unable to make it one formate:
1. 10/2/2016 12:00:00 AM
2. 18/2/2016 2:30
Can anybody help to calculate the date in "dd/mm/yy" formate and number of weeks.