Forum Discussion

Cuto05's avatar
Cuto05
Copper Contributor
Apr 13, 2023

Obtain a month column from only a day value

Hi, I have this issue. I'm working with a column that only has day numeric value. From 1-31 (January) and then it's start over from 1-28(February) until the end of the year. To add complexity every d...
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Apr 14, 2023

Cuto05 

If it's what I think it is, you could use:

=LET(
    dates, SEQUENCE(365, , DATE(2023, 1, 1)),
    REDUCE("All Dates", dates, LAMBDA(a, v, VSTACK(a, EXPAND(v, 8, , v))))
)

Resources