Excel Forum
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 614: Extract Full Date from Monthly Dates Listed As Text -- Pivot Table


See how to Extract Full Date from Monthly Dates Listed As Text using the REPLACE function to Insert Text. Then see a Year Year Over Year and Month Over Month Pivot Table using Value Field Settings Show Values As % Difference From in a Pivot Table.





Got a Question? Ask it Here in the Forum.