LinkBack URL
About LinkBacks
Hello Experts
I need a formula which return week starting from Thursday to Wednesday for week days and week no?
Hello Experts
I need a formula which return week starting from Thursday to Wednesday for week days and week no?
post an excelfile, without confidential information, and the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Expert !
Can it possible to get the sum of data based on week starting from Thursday end with Wednesday?
File attached
You did not add the desired result.
See the attached file (the green cells).
Please reply if this is the result you would like to see for the weeknumbers.
After that we can continu with your other question.
Edit:
this will only work in the versions excel 2007 and higher.
in your profile you add you use excel 2003 (that is correct?),
since you added an excel 2007 file in #3.
Hello Expert oeldere
Exactly it is giving the same results starting with Thursday week and end with Wednesday . Thank you.
My other question I need to make the data on weekly basis same start with Thursday to Wednesday.
sorry I am using excel 2010 . I need to update profile .
With the macro below and after that a pivot table.
See the attached file.
Please reply.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks