- Date should be in DD/MM/YYYY format as Tally do not support any other format.
- Make sure you are uploading the latest format of the EXCEL.
Note* :- Kindly click on the any Date in your sheet. Date should be seen exact same in the formula bar as Date in the cell. Check the below image (click on image to zoom):-