How can you change the date format for calculation in Microsoft Excel?

Normally the date format will follow your computer system. Therefore if you would like to completely change the way it shows up, you will need to change the default of your computer date display.

If you use Windows 7, click on the time and date at the bottom right corner
> click on "change date and time setting" then
> click on "change date and time"
> click on "change calendar settings"
> now just change the way you would like it to be looked like.

Done

 How can you change the date format for calculation in Microsoft Excel?