Excel Forum
Similar Content
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...
Getting Data from a UserForm
Tutorial: How to get data from a UserForm in Excel, including from: text inputs (TextBox), list boxe...



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.