+ Reply to Thread
Results 1 to 2 of 2

Read live data by week numbers

  1. #1
    Registered User
    Join Date
    11-29-2019
    Location
    Rotterdam
    MS-Off Ver
    Google Docs (online)
    Posts
    1

    Question Read live data by week numbers

    Looking for an assumptively simple formula, but I can't seem to figure it out. I want to place a "live overview pane" in a financial report (columns A&B).

    The yellow B3 needs to show the current capital (green) - per week (purple).
    For instance: It's Sunday, December 15th. B3 tells me whatever has been calculated in D14. The next Monday, starting a new week, I want B3 showcasing whatever is calculated in F14.

    I've fiddled with the =(WEEKNUMBER()) options and read a lot of threads here, but am not achieving my goal through this.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Read live data by week numbers

    Hello McvW and Welcome to Excel Forum.
    Perhaps this will help someone can translate an array entered formula into google docs.
    1. Change the dates in row 8 to reflect the end of the time period instead of the beginning.
    2. The current date is placed in cell D1.
    Note that for the purpose of illustration D1 is populated 12/16/2019 as mentioned in post #1. When the file is actually in use D1 could be populated using: =TODAY()
    Test by changing the date in D1 to 12/15 or any date on or before 12/27
    3. B3 is populated using the array entered formula*: =SMALL(IF(C8:G8>=D1,D14:H14),1)
    *Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with Pivot - Need to get current week and next week numbers
    By Beso90 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2019, 03:54 PM
  2. [SOLVED] Formula doens't read numbers in Imported data from OBI
    By modytrane in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2018, 04:00 PM
  3. [SOLVED] Count Week numbers given start and finish week number
    By Vassen in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-30-2016, 01:59 AM
  4. Parsing HTML to read live scores from Livescore.com web site
    By metalacos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2014, 12:07 PM
  5. Excel Live VLookup Live in spreadsheet - Quick way to find them?
    By CHR15T1N4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2013, 07:33 AM
  6. Live Numbers and Colour Rows
    By Hornstinger in forum Excel General
    Replies: 4
    Last Post: 06-06-2012, 07:09 PM
  7. How to Create Static numbers from a live formula
    By john dalton in forum Excel General
    Replies: 1
    Last Post: 10-07-2011, 11:02 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1