update a formula for the result are with capital initial

[Vinhas]

Hi Everyone,

I have a formula that give the date of payment. ("L19 to L22").
I would like to update the formula for the result (month) come with capital initial.

Thanks for your help.

Regards,

[Glenn Kennedy]

So 06 January 2023 would look like 06 J 2023.... or what??

[Vinhas]

I would like appears 6 of January of 2022

[HansDouwe]

Please format your cell: custom format: d of mmmm of yyyy (or if your local setting is Portuese: custom format: d of mmmm of aaaa)

[Vinhas]

I Try what you tell me but don't go. Can you please give me a example in the sheet I send ???

[AliGW]

Custom date formatting applied as suggested in post #4 in the attached.

[Vinhas]

thanks but is not what i need .

What I would Like is the cell in sheet (that have already a formula) give me "6 de Janeiro de 2022" instead of "6 de janeiro de 2022"

[Vinhas]

You still don't have the first letter of the month in capitals.

[Glenn Kennedy]

This is what I see, in your ORIGINAL sheet:

1. Is this what you want?

2. What do you see?

[Vinhas]

Yes Is that what I want !

I have in the first line "06 january 2022" and I want as you send me "06 January 2022" . How can I change it ??

[Glenn Kennedy]

I did NOTHING. That is exactly what I see immediately afer orpening your file.

[Glenn Kennedy]

What locale is that cell range set to??

[Vinhas]

I send you again the file.

thanks

[Glenn Kennedy]

It's the same. I see it capitalised. When YOU open it, what locale is set for those cells?

[Vinhas]

I think the problem is to combine in the same formula and cell the 2 formulas that i Have:


1: =SE.ERRO(SE(J35=0;"";DIA(J35)&" de " & INICIAL.MAIÚSCULA(TEXTO(J35;"mmmm"))&" de " & ANO(J35));"") and......
2: =SE.ERRO(MENOR($J$35:$J$74;CONTAR.SE($J$35:$J$74;"<="&MÁXIMO($L$18:$L18))+1); "")

[Glenn Kennedy]

I asked you a question. What is the answer?

[Vinhas]

The sheet I send you in attchament is 1 of maybe 10 sheets in the same file.
I understand that the sheet I send you read information from another sheet of the file.
I supose maybe wrong, for give a solution for my problem is not necessary send you the entire file with all the personal information.

[HansDouwe]

My local setting is dutch and I see 6 januari 2022.
I can not easy change the j in a J because in dutch you write januari with a j and not with a J.

You can easy choose for an other language and you get a capital if a capital needs in that language.
If I chooce Portuguese [Portugal] I get 6 de janeiro de 2022, because conform Excels Portuguese date settings you have to wirite the month in a date not with a capital in Portuguese.

Is this Excel's Portuguese translation of the month in a date without a capital not right?

[HansDouwe]

Indeed, but I wonder why you would want to, because according to the Excel translators you should not capitalize the month in a date in Portuguese.
That's why I asked you, do the Excel translators get that wrong?

Also according to google translate you should not capitalize the month in a date in Portuguese.