top of page

Different Date formats in Same Column

When you get data with multiple date formats in same column, it may result errors while transforming the Data.

I have noticed that many business data users are clearing those errors manually, which may cause delay in final report creation / inaccurate results !

In this video I have explained how to transform such columns where multiple date formats are placed and resulting errors while transforming the data!

6 views0 comments

Recent Posts

See All


The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial and even an Excel file to follow along with. #excel #lambda http

bottom of page