In this Excel Tutorial I will show you how to use Year function in Excel 2010.
For purpose of this tutorial I use packing slip template.
Year function allows us to returnee Year from a Date. I will show you base on the example.
Below I select my date on my invoice. I go to formulas bar select equal-Year and I open parenthesis. You can see that after parenthesis there can be only one argument.
In the parenthesis I select Date and I close parenthesis. The result is that Year function returnees me year from a date.
You can find Year function if you go to Formulas tab and click Date & Time. When you scroll down you will find Year function. I just click on it.
I get the Function Arguments window in click on Serial Number number and select Date-click OK.
I get exactly the same result like in previous example.
I hope this Excel Tutorial was helpful.
Katie and Emil