Excel date formatting into another column

Solved/Closed

Hezron - Apr 15, 2012 at 05:32 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 16, 2012 at 02:31 PM

Hello,
I want to check using IF function in one column and change the date format to another column from MM/DD/YYYY to has DD/MM/YYYY in excel 2010. If anybody can assist plz tell me.

Excel date formatting into another column
Excel date format dd.mm.yyyy - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to clear formatting in excel - Guide
Position formula in excel ✓ - Office Software Forum
Auto serial number in excel based on another column ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 16, 2012 at 02:31 PM

Not sure if you need to compare or display, but i am thinking that either TEXT function or DATEVALUE function should help

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Date formatting in dd/mm/yyyy

Conditional format based on another cell containing text

Similar discussions

Subscribe To Our Newsletter!