Excel Formula Text

[Pinaceous]

Hi All,

I'm working with today's date on my sheet.

For example; in cell A42 I have:

=TODAY()

Cell A42 is formatted, where the Format Cell is structured ddmmmyyyy.

So, using today's date of 04/19/2024, cell A42 will return it as 19Apr2024.

If I want to reference cell A42 as "TEXT" in cell A43, how would this be accomplished?

Because right now I'm getting an error.

Please help!

Thank you!
pinaceous

 

[Cubist]

You put the double quotes around "ddmmmmyyyy" instead of A3.

 

[Michael M]

Hi Pin
Formula should be

=Text(A43,"ddmmmyyy")

 

[Pinaceous]

Hey guys!!!

Thank you both!!!

That did it!


-pin