Excel has many different functions including a number of Date functions. These functions will allow you to put in the current date, current date and time, pulling out the day, month or year.
Here in this tutorial you will get started with using them.
Gary Schwartz's Blog 