I have downloaded a report in csv file from our company service software. I have saved the file in "xlsx" format. I am trying to count days between the two dates but the results return with "#VALUE!" error. I have tried hard to format the dates in the "dd.mm.yyyy" format using format cell but nothing happening. How do i calculate the number of days between the two dates. I even tried MS expert advice through MS Support feature available with in the excel application. But they failed to provide any solution. Hoping to find a solution in the community.
Attached is the file i am trying to calculate number of days. Please someone help me.