Show date as Mmm YYYY

[D-Spark]

On a worksheet in cell D3 I have entered a date in the format DD/MM/YYYY
What I want to acheive is place a formula in E3 to show Mmm YYYY derived from D3 value

Anyone able to advise on the formula

 

[DonkeyOte]

=TEXT(D3,Mmm YYYY")

 

[Jonmo1]

Are you planning on doing any calculations on the NEW date in E3? If So, just put
=D3 in the cell, and format the cell with a custom format of "mmm yyyy"
That way, the actual date stays the same and can be used in calculations.

If no calculation is needed on the cell E3, you can use this

=TEXT(D3,"mmm yyyy")

Hope this helps..