Sun 03 Sep 2017

Tips & Tricks 162 - Convert a Month Name to Month Number

By |Sunday, September 03rd, 2017|Categories: Tips and Tricks|Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , |0 Comments

Suppose, you have text denoting month in cell A1. Let's say A1 = "Sep" or A1="September", then you can use following formula to convert this to month number

=MONTH(1&A1)

=--TEXT(1&A1,"m")

In case, cell A1 contains  the partial month name say "Septe", then in place of A1 in the above formulas, you can write LEFT(A1,3).

Sat 12 Jul 2014

Tips & Tricks 31 - Generate Month Names Jan to Dec in Text or January to December

By |Saturday, July 12th, 2014|Categories: Tips and Tricks|Tags: , , , , , , , , , , , , , |0 Comments

1. Put "Jan" without quotes in a Cell. Let's assume this is in cell A1 here. If you want to generate full names of the month, put "January" without quotes.
Note - Start month can be any other month also. "Jan" has been chosen for illustration purpose only. The output will be starting with the month whatever has been put in cell A1.

2. Drag the bottom left corner till row 12 by pressing left click. It will automatically generate the names of the month.

OR

3. Drag the bottom left corner till row 12 by pressing right click.

4. Leave Right Click.

5. From the menu which pops up, select Fill Months.

1