+ Reply to Thread
Results 1 to 2 of 2

Display Current Balance based on Todays date

  1. #1
    Registered User
    Join Date
    02-13-2019
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    1

    Question Display Current Balance based on Todays date

    Hi, im trying to create a spreadsheet to keep track of savings for multiple different things which all go into the same bank account, eg. gas, electricity, holiday fund etc. I am paid every two weeks and so each "virtual" account will be paid into every two weeks. I have decided to create multiple sheets for each items projected savings and one overall Totals sheet. What i need is a formula which will display the current balance in the account based on todays date. It would need to look at column "A" and see which fortnightly period today is part of and then select the appropriate cell in the Balance column "D" and display it in G4. Is this possible? Any help would be greatly appreciated. Thanks! Excel formula puzzle.jpg

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Display Current Balance based on Todays date

    Hi, welcome to the forum

    It is always better if you include a sample workbook for us to play with.

    Having said that, perhaps something like
    =index(D:D,match(today()+7,A:A,1)
    (Untested)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 6
    Last Post: 06-14-2018, 03:05 PM
  2. Display a date for the following Sunday based off of current date
    By LeapingLizard in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-19-2017, 02:37 PM
  3. Replies: 4
    Last Post: 06-12-2014, 11:37 AM
  4. [SOLVED] Display Value Based on the current date.
    By DLC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2013, 04:46 AM
  5. UserForm - Display todays date
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-16-2011, 01:38 AM
  6. Using VB to find a range based on todays date and todays date +30
    By Steve_al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 09:31 AM
  7. Todays date, but not current time
    By Slongy in forum Excel General
    Replies: 4
    Last Post: 06-04-2009, 12:36 PM

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