Iโm trying to extract month and year from a date.
I found one that does month.
is it possible to do month and Year?
i tried to extract year only but test returns no result.
INDEX(
LIST(
โ2019โ, โ2020โ, โ2021โ, โ2022โ, โ2023โ, โ2024โ,
โ2025โ, โ2026โ, โ2027โ, โ2028โ, โ2029โ, โ2030โ
),
YEAR(TODAY())
)
Solved! Go to Solution.
Just YEAR(TODAY())
What do you actually want to do with this formula? Do you want to find where this 2020 is in the list?
If date is listed as 1-9-2020.
I want to extract January 2020
MONTH(โ1/9/2020โ) returns 1.
YEAR(โ1/9/2020โ) returns 2020.
The article you linked to shows how to use MONTH, LIST, and INDEX to change the 1 into โJanโ. You can copy that and change it to full month names. You donโt need to do anything fancy for the year.
CONCATENATE(
INDEX(
LIST("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" ),
MONTH([Date])
),
" ",
YEAR([Date])
)
That should get you most of the way there, youโll just need to make some minor tweaks.
thank youโฆworks
Thanks this works fineโฆ
Try:
TEXT([Date], "MMMM YYYY")
Oh yeah, I forgot that we recently got this feature.
wowโฆthis one makes me feel really stupid.
you out it in such a simple way and of course working.
It shouldnโt. This is a pretty new feature and youโd have to be paying very close attention to have discovered it.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |