I am using this formula but gives me #VALUE error
=STOCKHISTORY(C22,WEEKNUM(DATE(YEAR(O3),MONTH(P2),DAY(P2))),,1,0,1)
I desire to make the WEEK part dynamic.
Kindly see the attached file.
Thank you.
I am using this formula but gives me #VALUE error
=STOCKHISTORY(C22,WEEKNUM(DATE(YEAR(O3),MONTH(P2),DAY(P2))),,1,0,1)
I desire to make the WEEK part dynamic.
Kindly see the attached file.
Thank you.
The second argument of this formula needs to be a date, not a week number.
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.
Please try at P3
=LET(a,$P$2:P$2,b,LOOKUP(9^9,a),c,DATE(YEAR($O3),MONTH(b),1),d,c-WEEKDAY(c,16)+(COLUMNS(a)-MATCH(9^9,a)+1)*7,IF(MONTH(d)=MONTH(c),STOCKHISTORY($C$22,d,,1,0,2),""))
Thank you sooo much Bo_Ry. This works.
Dear Bo_Ry,
I made a change to the month column but unable to fix the formula, can you please help modify the formula.
Please see the attached file.
Thank you so much.
I get #VALUE error, can someone please help me fix this formula.
=STOCKHISTORY(A22,WEEKNUM($O32,11),,1,0,1)
I attach a sample file.
Thank you in advance.
See post #2 - the second argument requires a DATE, not a week number.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks