In this example, we are using the format “mmm d” for both TEXT functions in E5.
The results are joined with a hyphen using simple concatenation.
Note: the other examples in column E all use different text formats.
“March 1 - “).
Related functions
TEXT Function
The Excel TEXT function returns a number formatted as text.
in a text string with the number format of your choice.
More than one condition can be tested by nesting IF functions.
The IF…
Related videos
How to create a formula with nested IFs
