Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791
MS Excel 2007 Lecture # 27
  • The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default MS Excel 2007 Lecture # 27

    "Excel 2007 Date Function (An example)"


    The TODAY( ) function automatically retrieves the current date. It is useful for creating spreadsheets that continuously update themselves such as to determines the number of days a payment is overdue.
    The NOW( ) function is similar to the TODAY( ) function, except it retrieves the current date along with the current time.

    To demonstrate the use of Date and Time Functions: TODAY

    • Create a spreadsheet as follow:

    Name:  excel-2007-date-function-worksheet.jpg
Views: 293
Size:  23.2 KB


    • Click on the cell B3, where the answer will appear.
    • From the Formula tab, in the Function Library group, click the Date & Time icon and from the drop down menu, click the TODAY command.

    MS Excel 2007 Lecture # 27-excel-2007-today-function.jpg


    • From the Function Arguments dialog box displayed, click OK.
    • The today date will display on the cell B3.

    Note: If you directly type =TODAY( ) to the cell B3, the same result will appear. The following day, month and year functions are based on this date.

    To demonstrate the use of Date and Time Functions: DAY

    • Click on cell B4 and enter the following function:
      =DAY(B3)
    • Press the Enter key. You will notice that the current day of the month is displayed on the cell B4.


    To demonstrate the use of Date and Time Functions: MONTH

    • Click on cell B5 and enter the following function:
      =MONTH(B3)
    • Press the Enter key. You will notice that the current day of the month is displayed on the cell B5.


    To demonstrate the use of Date and Time Functions: YEAR

    • Click on cell B6 and enter the following function:
      =YEAR(B3)
    • Press the Enter key. You will notice that the current day of the month is displayed on the cell B6.
    • Here are the results:

    Name:  excel-2007-date-function-result.jpg
Views: 309
Size:  22.3 KB







    The Excel 2007 DATE function is a quick and easy way to insert a date into a formula. DATE( ) accepts three numbers, each of which represents a different component of the date. Here's what it looks like:
    DATE(year, month, day) So, if you enter this formula into a cell:
    =DATE(2010, 1, 1)
    Excel displays the date 1/1/2010.


    Find Me On Social Networks

    Facebook | Twitter | Google+



 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •