RIght-click the cell

Choose Format Cells

Category = Date

Type = however you like it

Hi there,

Thanks for the response. But that's not what I am looking, sorry that I didn't explain it well when asking the question.

It's an FR paste function I guess, because it returns "2 Months Ended 5/31/2021", 
and I want it to return like "2 months Ended May 31, 2021"

Again, I would appreciate if you can provide step by step instruction.

Thanks,

Zia

Hi there,

Thanks for the response. But that's not what I am looking, sorry that I didn't explain it well when asking the question.

It's an FR paste function I guess, because it returns "2 Months Ended 5/31/2021", 
and I want it to return like "2 months Ended May 31, 2021"

Again, I would appreciate if you can provide step by step instruction.

Thanks,

Zia

=FR("PERIOD")&" Months Ended "&TEXT(FR("END"),"Mmmm d, yyyy")

Thank you so much, it works!

Hi zia wang, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey