Converting yyyy-mm-dd to yyyy-mm

[JulieBee64]

In Excel, I am trying to convert the date yyyy-mm-dd to yyyy-mm (in my database), so that my pivot table doesn't included every day of the month. Is there a simple way to do this?

[Rabbit]

You can use the year and month functions in Excel

[JulieBee64]

Thank you - that works for me!