Custom Formatting a Date in a Text Entry?

[The doomed]

I have a date in H34, 21/03/2009.

In I34 I have the same date again, except formatted as MMMM YYYY so its showing "March 2009".

In G10, I want the cell to read: Number at end of March 2009, with the month and year being taken from the date range. To be honest, I can get the year okay using the Year() function but cant get the month as cant convert it back from a numeric.

Any ideas?

 

[Richard Schollar]

Hi

Use TEXT:

=TEXT(H34,"""Number at end of ""mmmm yyyy")

 

[The doomed]

Hi

Use TEXT:

=TEXT(H34,"""Number at end of ""mmmm yyyy")

excellent, as ever

 

[Richard Schollar]

You're welcome - though to be honest that would be easier to read as:

="Number at end of " & TEXT(H34,"mmmm yyyy")

 

[Stormseed]

"Why y'all order a dead guy?" ~ Jayne Cobb, Firefly episode

Meaning, Mr. Richard ? You guys always use so difficult to understand terminology

 

[Richard Schollar]

Nhimit - it's a quote from a Sci_fi television series I have been watching! It likely won't mean a thing to you (or anyone else for that matter!) unless you have seen the specific episode I am talking about

Firefly is a great series by the way - I would highly recommend anyone to buy it

 

[Stormseed]

Buy Firefly ? Is it sort of a game or something or is it a TV series ? I think you had a typo of 'h' in my name and it looks awful

 

[Richard Schollar]

Oops - sorry Nimit!

Flyfly is the make of the spaceship in the series

 

[Stormseed]

Oops - sorry Nimit!

thats okay, sir

Sometimes, I do enjoy seeing you commit these mistakes atleast while typing

 

[Weaver]

Nhimit - it's a quote from a Sci_fi television series I have been watching! It likely won't mean a thing to you (or anyone else for that matter!) unless you have seen the specific episode I am talking about

Firefly is a great series by the way - I would highly recommend anyone to buy it

Have to agree on the series - made by Buffy creator Joss Weedon and significantly underrated. Seen the movie, Serenity?

BTW, haven't watched it for a while, so don't recall the reference.