Excel Forum



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.