Deleting the days in an Edate cell

[SirHart]

Hey everyone I could certainly use some help. I've been trying to figure out how to not have the days be present in my EDATE output. I am using Excel 2003.

Example

I am currently using the cell formula =EDATE($B$4, -12)

I want the user to be able to enter a date like "March 13, 2010" in the B4 cell and I want the EDATE cell to read ONLY the Month and Year, not the days, so in this case "March 2009". Is there any easy way to tweak the formula to do this? Any help would be very appreciated!

 

[RichardMGreen]

Is there a problem with formatting the cell to show just month and year?
It won't change the contents but will change what is visible.

 

[Peter_SSs]

If the formatting is not what you want, try

=TEXT(EDATE($B$4, -12),"mmmm yyyy")

 

[SirHart]

That did the TRICK! Thanks so much Peter_SSs