Date and time function in excel 2010

Date and time function in excel 2010,2007

Date and time function in excel 2010 with example

Date and time function in excel 2010 with example

Date and time function in excel 2010 : Date, time, datevalue, timevalue, now and today

1.   Date functions/Date functions with examplle

        Returns the number that represents the date in Microsoft office Excel date-time code.

=Date(year,month, day)

+ To add a number of days to a date, example as follow 

+ Use the date function to add a number of years, months and/or days example as follow :

     2. Time functions- time functions with example

Converts hours, minutes and seconds given as numbers to an Excel serial number, formatted with a time format

=time(hour,minute,second)

        3..Datevalue function/ Datevalue function with example

Converts a date in the form of text to a number that represent the date in Microsoft Office Excel date-time code

=Datevalue(date_text)

 4.     Timevalue function/Timevalue function with example

Converts a text time to an excel serial number for a time, a number from 0 to0.999988426.Format the number with a time format after entering the formula

=timevalue(time_text)

5. .Now function/ Now function with example

Returns the current date and time formatted as date and time

=Now()

 6.  Today function/Today function with example

Return the current date formatted as a date