Date Formatting in Excel
Want to display todays date or display a date in a different format. Here I show you
Display date in a different format, like July 1, 2015 or 1/7/2015 or 2015 July 1 or Wednesday July 1, 2015.
This is done with the properties of the cell.
For Time formatting go to Time Formatting
Go to More Number Formats if the choice is not the one you want.
Here you already have a certain number of preselected formats to chose from in order to format the time and date.
If this is not enough, then use CUSTOM selection to have a customized formatting.
Now you can use the following rule for date formatting
The format is just a combination of these Ys, Ms and Ds....like yyyy/mm/dd,ddd which will give you : 2015/07/01, Wednesday
Example: you want to change the date format to show the day of the week
27 July 2001 if you write dddd-d-mmm-y it will be Friday-27-Jul-01
To just have the Day: d
The day of the week: ddd or dddd
Just the Month: m or mm
Now you try....