Year formula

The year formula takes out the year in a numerical answer (ie. 2010) out of a date. Make sure that you use the number format for the date and not the date format, otherwise it will not work

This works very well for analyzing of data per year.

Things you can do with the year formula

• Summarize data per year by using a pivottable...contact us for more info
• Change the day or month but use the same year...contact us for more info

<-----Back to index