Next year's date function in Excel

=year(now())+1
The excel formula above will display next year's date within excel.  So, if the current year is 2012 then the formula will display 2013.

Read More..