Notifications
Clear all
Topic starter
Dear Members,
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.
Best Regards
ALi
Posted : 20/01/2021 6:43 am
Try
=WEEKNUM(VALUE(A2))
Posted : 20/01/2021 7:32 am
