LinkBack URL
About LinkBacks
Hi, I need a formula to indicate the week number - the details are explained in the attached workbook.
Thanks in advance
JD
Hi, I need a formula to indicate the week number - the details are explained in the attached workbook.
Thanks in advance
JD
Is this whayt you meant (in I3).
=INDEX($A$2:$A$7,MATCH(1,$F$2:$F$7,0))
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
Have you tried the WEEKNUM function?
Pete
Perhaps
Formula:
=SUMPRODUCT((TODAY()>=B2:B7)*(TODAY()<=D2:D7)*(A2:A7))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Cheers Glenn spot on mate, Pete I was using false dates as the week start numbers so unfortunately the weeknum wouldnt have worked, cheers any way mate.
Thanks
JD
You're welcome & thanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks