Convert weeknumber to "YYYY-MM-DD"

A proposal has not yet been provided

1. Select a blank cell you will return the start date (in our case we select the Cell B5), enter the formula: =MAX(DATE(B1,1,1),DATE(B1,1,1)-WEEKDAY(DATE(B1,1,1),2)+(B2-1)*7+1), 2. Select another blank cell you will return the end date (in our case we select the Cell B6), enter =MIN(DATE(B1+1,1,0),DATE(B1,1,1)-WEEKDAY(DATE(B1,1,1),2)+B2*7),

Hello Sir I can do it in few minute Sir :) im excel VBA macro and formula Expert :) Thank You Sincerely Pram

A proposal has not yet been provided

A proposal has not yet been provided

A proposal has not yet been provided

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on projects.

I have a very good command on MS Excel and I can deliver the task within an hour. Thanks .

Hello, I am interested in this job and able to complete it without any error. I am ready to start now. Let me start. Best regards, Mahfuz

I would be happy to convert the week numbers to dates for you. I can use the lookup function or something even simpler depending on how your data is arranged. I would just need to know what day you would like to start the week on- Sunday or Monday- so that I can program it correctly. I will remove all formulas prior to returning the sheet to you so that there are no issues in the future.

Dear Sir/Madam, Greetings, I am a Professional & Authentic Freelancer. providing excel data entry work from 5 years. according to your job requiremnets: willing to start a minor task such as convert week number to data format YY-MM-DD. let me know how much . as there are 10 members of team. so feel free. thank you

A proposal has not yet been provided

Do you have sample excel file where this formula needs to be done or i can make my own stuff and send to you ?

Hi, Please give me a chance to make your work done in time accordingly as desired. Besides this my expertise in MS Office, Presentations, Data Entries, Designing, PDF document, Google Spreadsheet, VBA, Macros and Typing. Your response is being awaited.

Hi, Do you want it as Excel function or VBA function/macro? I can do it as macro, weeks start on Sunday in your country? And the day converted should be a Sunday am I right? Regards,

Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

Greetings. I specialize in provide solutions for Business Administration, Data Base management, KPI design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated Excel spreadsheets including formulas creation, pivot tables and pivot charts. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. Also, I can teach you how to do the formulas yourself so if you can use this knowledge in the future. My work will give you the confidence to initiate a long term relationship. Thank you.

Hi there! I have already completed the work that you have put in your description. Looking forward to hear from you. Thank you. Warm regards, Naseef Ummer

Hi, I have done good amount of work in excel manipulation and you can refer to my profile. I can introduce formula to fix this excel conversion. Looking forward to work with you. Waiting for your reply.

Hello there, Required conversion can be done using a set of formulas, provided that you have weekday and year (or the year can be taken from current date) Please contact me if my bid suits you Kind regards, Alexander