As there are many error in ITC forms due to wrong Formatting for Date as text and not as Date Format due to which the excel file will throw errors as when you convert 01/01/2018 to text it’ll show 43101 and not 01-01-2018 to Convert the date format  01/01/2018 to 01-01-2018 automatically using excel formula

First convert the date to 01  01  2018 in each columns using text to columns click next  and in delimiters in others input / and select next and finish and Then convert to text (Alt+h+n)

Then use the formula in excel attached below for converting the same to dd-mm-yyyy in text format.

Rajat Solanki

[email protected]

Access Denied! Only Regstered Users Can Download The File "ITC form Errors in DATE format, How to Rectify?". Register Here or Login

Author Bio

Qualification: Student - CA/CS/CMA
Company: MGIRT & Co
Location: Bangalore, Karnataka, IN
Member Since: 05 Sep 2017 | Total Posts: 10
I am Rajat Solanki and Currently Studying CA and I am working at MGIRT & Co. Bangalore View Full Profile

My Published Posts

More Under Goods and Services Tax

One Comment

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

June 2021
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930