I need to Convert Date with Time to only Month / Year (non text form) so that I can sort the dates in a pivot table later. Cell e4 has the full date with time data.
Do you need to convert it or reformat it. If you convert it then it will be text. If you reformat it then it is showing only as mm/yy and the underlying value is still the numerical.
If the issue is that you want to sort/group them by just year and month (and ignore day and time), you could insert a column and make all the days equal to the first day of the month, and remove the time piece. You can then format it to only show month/year, and if you use this new field for grouping and sorting, it should do what you want.
For a date/time in cell A1, the formula will look like:
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.