Date

DATE for today,   

   1.       Go to> Formula> Date & Time> Date

      2.       In the Year text box enter Year(now())

3.       In the Month text box enter Month(now())

4.       In the Day text box enter Day(now())

5.       Click on OK

6.       You now have today’s date, 31-JUL-2012 as M/D/YYYY

Read More..

SECOND

How to display the seconds value in a specific time,

1.      Go to the Formula tab> Select the Date & Time drop down list> Click on SECOND

2.      The function argument window will popup

3.      In the Serial_number input box enter the required time including seconds

4.      I have entered "10:25:31"

5.      The resulting value of the seconds within the time is 31.

6.      Click on OK

7.      The result is now displayed in the active cell of excel

Read More..