Share via

MONTH function returns same value or an error

Anonymous
2022-03-08T22:30:25+00:00

my date format in cell B1 is m/dd/yy, i would like cell j5 to contain either the numeric for m OR the text for m. example 3/1/23 in B1 and cell j1 should contain m or 3.How can I do that?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2022-03-08T22:36:22+00:00

    With 3/1/23 in B1:

    =MONTH(B1) will return 3

    =TEXT(B1,"mmm") will return Mar

    =TEXT(B1,"mmmm") will return March

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments