Sponsored Link

There was an error in this gadget

Sponsored Link

Tuesday, July 7, 2009

Year Function

Year function is used to extract year from Date. It’s very useful when you want to summarize data at year level or you want to apply filter on year. This function in combination with other function is very useful in calculating past/future dates. I will share few examples of Year function in near future.

Formula: =Year(Date)

Click on image below to view enlarge

Yearfunc

Example1: Find the current year.

Formula: Year(Today())

Click on image below to view enlarge.

yearfuncexam

If you face any issue with replicating this example in MS Excel or understanding this function. I would suggest you to download Year function Excel file enclosed below

Year Function Example

Kindly let me know your view and experiences about using Year function. For free updates subscribe here.

We assure you knowledge, not SPAM!

0 comments:

Post a Comment