I am explaining here some date related functions in Microsoft Excel. Microsoft Excel and Microsoft Office users will get advantage from this tutorial.

This is a useful function and work with Date and Today functions.

=Text(Today(), "ddd")
Example above will return current week day name like (Wed, Thu) etc.

=Text(Today(), "dddd")
Example above will return full current week day name like (Wednesday, Thursday) etc.

=Text(Date(1977,11,06),"ddd")
Example above will return week day name of given date. Example above will return "Sun" (In this way you can get week day name of your birthday).

=Text(Date(1977,11,06),"dddd")
After increasing of one d you can get full week day name of your birthday.

=Text(Today(),"mmm")
=Text(Today(),"mmmm")
Examples above will return current month name (Aug and August)

=Text(Today(),"yyy")
This example will return current year (2008)

=Text(TODAY(),"dd-mmm-yyy")
This example is showing current date in a custom format.

Get date difference
This method is useful for getting days difference of a date from today.

=Today() - Date(1977,11,6)
Example above will return number of days since 06-Nov-1977 to today or current date.

Other functions
Here are more functions to get day, month and year from a date.

=Day(Today())
Function above will return month day number of current date.

=Month(Today())
Function above will return month number of current date.

=Year(Today())
Function above will return current year.