Convert date to YYYY-01

[spyldbrat]

Hello,

How do I convert a date to display the year and month #?

03/19/18 to display as 2018-03?

 

[Special-K99]

"to display"

So retain the value 03/19/18 but just display the date's year and month

Format the cell
Custom format
yyyy-mm

 

[Scott T]

format the cell as

yyyy-mm

 

[spyldbrat]

format the cell as

yyyy-mm

So simple yet it took me forever to find it!!!! Thank you.