Get only the month of changing date

Hello there,

i want to write only the month of the above date into the row below. With any formula i typed in, i get errors. Also if i tried to parse it with the following code:


it doesn´t work.
For better understanding here are some pictures:

After: it should look like this

i hope you can somehow help me.

Kind regards!

Hi @mcLauge, you can refer to this link. You can give the date in the above row as a variable:

Hope it helps!

@mcLauge At first Can you loop through the values in the Excel using For Each and Check how the date value appears in a Message Box, that will give you an Idea if the Date format you have entered is the Correct format or not.

1 Like