Dear Excel Forum members,
First of all, I want to thank you all for your big help with my former questions!
Today I have the following problem: One cell contains the following function:
=TEXT(C5, "yyyy")&-WEEKNUM(C5)
This function will transform a date from another cell, e.g. 01/02/2013 (Month/Day/Year) into the format 2013-1. But for further calculations I need the format like 2013-01.
I already tried several hours by myself to find the answer, but so far I had no success. Therefore, I hope someone could support me here!
Thanks and best regards
Bookmarks