SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,503
- Office Version
- 2021
- Platform
- MacOS
Hi Experts
Just now I encountered a strange situation.
The TEXT function is not returning correct month name from a date. See Column D & E below
I must be doing something really silly and ignoring something basic to get into this trouble.
Please help
Thanks in Advance
Just now I encountered a strange situation.
The TEXT function is not returning correct month name from a date. See Column D & E below
I must be doing something really silly and ignoring something basic to get into this trouble.
Please help
Thanks in Advance
Book1 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
2 | Date | Month | Text | Check | ||
3 | 10/31/24 | 10 | Jan | 1 | ||
4 | 11/30/24 | 11 | Jan | 1 | ||
5 | 12/31/24 | 12 | Jan | 1 | ||
6 | 1/31/25 | 1 | Jan | 1 | ||
7 | 2/28/25 | 2 | Jan | 1 | ||
8 | 3/31/25 | 3 | Jan | 1 | ||
9 | 4/30/25 | 4 | Jan | 1 | ||
10 | 5/31/25 | 5 | Jan | 1 | ||
11 | 6/30/25 | 6 | Jan | 1 | ||
12 | 7/31/25 | 7 | Jan | 1 | ||
13 | 8/31/25 | 8 | Jan | 1 | ||
14 | 9/30/25 | 9 | Jan | 1 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B3:B14 | B3 | =EOMONTH(TODAY(),SEQUENCE(12,,0,1)) |
C3:C14 | C3 | =MONTH(B3) |
D3:D14 | D3 | =TEXT(MONTH(B3),"mmm") |
E3:E14 | E3 | =TEXT(MONTH(B3),"m") |
Dynamic array formulas. |