Sunday 27 September 2009

Entering the current date into a cell in Microsoft Excel

Within Excel there is a method of entering a formula that will automatically enter the current date. The formula is as follows :

=Today()

It should be noted that there is one final step to show only the date as the above will return the current date AND a time that will show as zeros. In order to only show the date in the cell. Highlight the column select format and then choose 'Date'.

As soon as this final step is complete you will be left with the current date.

No comments:

Post a Comment