Week Day Date
#1 (10/23-10/29) Thursday ?
#2 (10/30-11/05) Thursday ?
Each week comes with a range and a Specific day, but the specific date have been adding manually
Thanks any help is appreciated.
Week Day Date
#1 (10/23-10/29) Thursday ?
#2 (10/30-11/05) Thursday ?
Each week comes with a range and a Specific day, but the specific date have been adding manually
Thanks any help is appreciated.
It's not clear from your description what day you are trying to produce
Try
=TEXT(MID(A2,5,5)+0,"dddd")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
The date range is a week that is pulled from the DB. The Day is predetermined. I'm looking to identify the specific date with in the range.
Example #1 (10/23-10/29) being the range and Thursday is predetermined for our process. In this case the Specific date for Thursday within the range of the week should be Oct 25th.
I'm looking to set up a formula to do this.
I attached the sample with what my attempt, however if you see in D3 there isn't 32 days in a month..
Let me know if that clarifies
Last edited by k2hunter; 10-16-2018 at 10:43 AM.
Maybe this?
=DATEVALUE(MID(A2,FIND("(",A2)+1,5))+7-WEEKDAY(DATEVALUE(MID(A2,FIND("(",A2)+1,5)),15)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
C2 (to extract 1st day of the date range):
=DATE(2018,LEFT(MID(A2,FIND("(",A2)+1,5),2),RIGHT(MID(A2,FIND("(",A2)+1,5),2))
D2 to convert desired day name to number:
=MATCH(B2,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},0)
E2 to return the corresponding date:
=C2-WEEKDAY(C2,1)+IF(WEEKDAY(C2,1)>D2,7+D2,D2)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Please try at C2
=--MID(A2,FIND("(",A2)+1,5)-WEEKDAY(--MID(A2,FIND("(",A2)+1,5),2)+MATCH(B2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
thank you this works!
I do appreciate all other responses.
No idea who you were talkig to, but....
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks