Excel Forum
Similar Content
How to Use Dates in Excel
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Pass Arguments to a Macro Called from a Button or Sheet in Excel
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 612: Pivot Table Year Over Year Sales Calculation From Dates Listed As Text


See how to create a Year Category for a Pivot Table from Dates Entered as Text using the RIGHT function and the Ampersand & (Join Symbol). Then we can calculate Year Over Year Sales showing Percentage Change using the Show Values As % Of Value Field Setting.





Got a Question? Ask it Here in the Forum.