I have an 2010 excel file with 200 user details and their date of birth is populated in dd/mm/yyyy ( 29/06/2001)on one of the colums.
I want to convert this format into ddmmyy (290601) . This data is on colum H and if i go to the particular row and remove the / and 20, some other date populates.
Please let me know if there is a way to achieve this.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…