How can I get a simple list which includes these 3 years as below?
2023（This year）
2022
2021
NV
MV
（Because it is a column for wine vintage, the list includes NV none-vintage and MV multi-vintage）
My first expression below won’t work.
And the second expression below exports year with a comma.
And the third expression below won’t work too.
What can I do?
Thank you all every time!!
Please try TEXT() functions instead. Something like
LIST(
TEXT(TODAY(), “YYYY”),
TEXT(TODAY()-367, “YYYY”) ,
TEXT(TODAY()-732, “YYYY”),
“NV”,
“MV”
)
Please test well for edge case dates ( 31st December, 1st Jan, 28th Feb, 29th Feb, 1st March etc.)
This should do it, right?;
LIST(
TEXT(EOMONTH(TODAY(), 0), "YYYY"),
TEXT(EOMONTH(TODAY(), -12), "YYYY"),
TEXT(EOMONTH(TODAY(), -24), "YYYY"),
"NV",
"MV"
)
Yes, that will also be another nice way @SkrOYC