Using Date Functions in Excel 2003
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers using the most commonly used date functions used in Excel: =TODAY() and =NOW()
Like all functions in Excel, entering date functions is very straightforward – just type in the function in the cell where you want the date or time to appear.
Computer Serial Date
There are no arguments to enter for the =TODAY() or =NOW() functions. Both of these date functions draw their data from the computer’s built-in clock. Computers store the date as a number representing the number of full days since midnight January 1, 1900 plus the number of hours, minutes, and seconds for the current day. This number is called a serial date.
=TODAY()
This function returns the current date. To display the date in a different format than the default:
- Click on Format > Cells in the menus to bring up the Format Cells dialog box.
- Click on the Number tab.
- Select Date in the Category window.
- Pick from the available formats in the Type window.
=NOW()
This function returns both the current date and time. To change the display to show just the date, follow the steps for the =TODAY() function above.
To change the display to show just the time:
- Click on Format > Cells in the menus to bring up the Format Cells dialog box.
- Click on the Number tab.
- Select Time in the Category window.
- Pick from the available formats in the Type window.
Date Functions in Excel 2003 | Source and Code System…
It’s the best time to make some plans for the future and it is time to be happy. I’ve learn this put up and if I could I wish to suggest you some fascinating things or tips. Maybe you can write subsequent articles referring to this article. I want to…
Date Functions in Excel 2003 | Source and Code System…
Hey! Superb article! I am a ordinary visitor to your site (far like addict ) to your website but I had a concern. I am just far from being positive whether it is the right place to question, but you have no spam comments. I get comments each day. Possi…
Date Functions in Excel 2003 | Source and Code System…
What a super blog! to much info and a very short life hehehehe keep it up, good work…
Date Functions in Excel 2003 | Source and Code System…
How do you do? We just loves your gorgeous blog thank you and pls don’t stop!…
Great Job…
keep it up I love this site…