Format the cells you want to custom and type in "yyyy" if you are on the english excel version, then set the formula to =Today() or =Now()

The cell(s) should display the current year now, you can do the same for months. ie, "mmmm" instead of "yyyy" dont include the "" :p

Hope this helps, cheers