Thank you so much on your nice work indeed Anders. Good man!
Thanks Ander, I think is my version of excel. I understand that my previous attachment didn't finish the power query because when I try, the result di...
Hello Anders, no joy, I try to use power query in my worksheet. But once I merge, all dates in column A still paste to the new column, even the date e...
I finally manage to modify Riny's work. Now dates will be auto generated after entering a year. I also used Index + aggregate together to return all ...
Hi Riny, Thank you so much on your reply. Your work is nice. I look back on Anders and Hans solutions, all those problem months first day was on...
Thank you so much guys. Indeed, some problem was found on both Hans and Anders's solution. I found that in Feb 2023, the second week Monday which I...
Hi Anders, Thank you so much on your reply. The link you sent I actually look at it before and nevertheless, somehow this is the ISO calendar. M...