Error in format when Tagged

[Rafay Ahmed]

Attached is the picture, where when I am writing a phrase = "The month of " & S4 its not giving me date in that format.

Kindly help me fix this.

 

[AliGW]

Try this:

= "The month of " & TEXT(S4,"MM/DD/YY")

 

[Rafay Ahmed]

Thank you so much @AliGW

 

[AliGW]

You're welcome!

 

[Peter Bartholomew]

@AliGW has shown a standard US date format but pretty much anything is possible from there, including the translation of dates into other languages. In this case
= "The month of " & TEXT(S4,"MMMM-YYYY")
might fit the pattern.

= "Le mois de " & TEXT(S4,"[$-40C]mmmm-yyyy;@")
would be entirely a different thing!

 

[AliGW]

Yes - it could just as easily be this:

= "The month of " & TEXT(S4,"DD/MM/YYYY")

 

[vletm]

Would need 'long Month' and year
like = "For The Month of " & Text(S4,"mmmm-yyyy") without day.
... if Rafay Ahmed wants result as in that sample file.

 

[Khalid NGO]

Or use the custom format:
"For the month of "mmm-yy

Regards,

 

[Peter Bartholomew]

@Khalid NGO

I like that idea. Apart from anything else, it means that the heading is still usable as a reference. The main problem would be that a number-formatted cell does not spill over to adjacent cells; either the cell would need to be wide or it would need to be merged with the adjacent cell.

Another option is to right justify the text in one cell and left-justify the formatted date in the next. Provided one clears the display of gridlines, that can convey the same message.

 

[Khalid NGO]

Hi Peter,
Yes you are right, cell need to be wide or merged to show complete text and date.

But using custom formatted cells we have advantage if the cell needs to be used for further calculations.

 

[Rafay Ahmed]

Or use the custom format:
"For the month of "mmm-yy

Regards,

I altered this myself like the way you did,
Thank u

 

[Rafay Ahmed]

View attachment 55953 View attachment 55954
Would need 'long Month' and year
like = "For The Month of " & Text(S4,"mmmm-yyyy") without day.
... if Rafay Ahmed wants result as in that sample file.

Thank you