the new column created by the formula would contain the values "January", "February", "March", and "April" respectively, since 1*29 = 29 corresponds to January, 2*29 = 58 corresponds to February, 3*29 = 87 corresponds to March, and 4*29 = 116 corresponds to April.
thanks for the video. My issue is i have 2 column : In the first i have month number 1 , and in the second 2021. I want to create a third column which gives me full date end of month: 31.01.2021. Thanks for your help.
Hi S.K thanks for watch my video. You need to select both column and merge them and them change the merged column type to DATE. Then Add custom column where you need to write Date.EndOfMonth(select your merged column)=You have End of Month Date. Please feel free to send the you worksheet at info.arecorder@gmail.com should you have any confusion.
Very Direct. Thank you.
How did you come up with the 29 though?
Many thanks for your video!! Amazing solution!!
This was very helpful. thanks
Thanks so much, everything else I was trying to do wasn't working. This solved it for me :)
only took an hour to find this solution. THANK YOU!
half an hour more for me
Excellent !!!!
Thanks :)
Thanks! :)
very nice brother
Sorry, can't see the typed formula
Wow, thank you. Why do you multiply for 29?
the new column created by the formula would contain the values "January", "February", "March", and "April" respectively, since 1*29 = 29 corresponds to January, 2*29 = 58 corresponds to February, 3*29 = 87 corresponds to March, and 4*29 = 116 corresponds to April.
@@girdhar3224 yes, I got that after thinking about it. It took ma while to get. Thank you, though.
@@girdhar3224 Sorry, but I still don't get it. What would be the exact point of using 29? Why not the number 1, for example?
@@jorgeluismartineznieto8969 The formula gives you a day of the year.
if you want to make video make it clear, don't waste others time!
thanks for the video. My issue is i have 2 column : In the first i have month number 1 , and in the second 2021. I want to create a third column which gives me full date end of month: 31.01.2021. Thanks for your help.
Hi S.K thanks for watch my video. You need to select both column and merge them and them change the merged column type to DATE. Then Add custom column where you need to write Date.EndOfMonth(select your merged column)=You have End of Month Date. Please feel free to send the you worksheet at info.arecorder@gmail.com should you have any confusion.