Forum Discussion

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

NikolinoDE

Platinum Contributor

Apr 14, 2023

Cuto05

As far as I could understand...

One way to add a month column to your data would be to use a formula that takes into account the repeating pattern of the day values.

For example, you could use the CEILING function in combination with the ROW function to calculate the month number for each row.

Here’s an example formula that you could use in the first row of your month column:

=CEILING((ROW()-ROW($A$1))/8/31+1,1)

This formula assumes that your day values start in cell A1 and that there are 8 rows for each day.

You can adjust the formula as needed to match your data.

Once you have entered the formula in the first row of your month column, you can then copy it down to the rest of the rows in that column.

I hope this helps!

NikolinoDE

I know I don't know anything (Socrates)