For Example, In excel we have the following details,
Date Week number Weekday Result
05.07.2019 28 1 28/1
Q.What VBA should do?
A.When user will give input as 05.07.2019 in the Command Button ,the output should be 28/1.
thanks in advance ! Please help
Assumes your data in Column A starting in row1. Result appears in Column B
My code returns the result of 27/6. 27th week of the year and the 6th day of the week.
Please Login or Register to view this content.
Please explain how you achieve 28/1 as the expected result.
Last edited by alansidman; 07-04-2019 at 09:50 AM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Why 28?
ISOWEEKNUM function (in German version of Excel: ISOKALENDERWOCHE) would return 27.
I just noticed you use Excel 2010 - as far as I remember, this function has been introduced only with Excel 2013, so you may use: WEEKNUM ( in German version KALENDERWOCHE ) and second argument 2 to get ISO numbering.
PS. To get better answer let us know where the input date is stored (in a cell? in a variable?) and how would you like the result to be shown (written to variable, displayed in message box, written to a cell?
Best Regards,
Kaper
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks