Sharepoint Calculated Columns with Date

Date Time Format of Calculated Columns in Sharepoint

Here Some Example How to Convert DateTime Format into Various Date And Time Format :

Some Good Tricks of Play with Sharepoint Date Time Field :

For Example

// Convert Value in dddd-mm-yyyy format

=TEXT([TODAY],"dddd-mm-yyyy")

//Retrive only Month in Text Value

=CHOOSE(MONTH([Created]),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

// Year Only Display without Comma

=TEXT(YEAR([Start Date]),"000")

//Only Month , Year , Date

=Month([START DATE])

//Find Out Quarter of Date

=ROUNDDOWN(((INT(MONTH([Start Date]))-1)/3),0)+1

Source: http://chrissyblanco.blogspot.com/2007/07/sharepoint-calculated-columns-with.html