+ Reply to Thread
Results 1 to 2 of 2

Return Value if date in a range of cells falls between two dates

  1. #1
    Registered User
    Join Date
    08-26-2020
    Location
    Denver, CO
    MS-Off Ver
    Google Sheets
    Posts
    1

    Cool Return Value if date in a range of cells falls between two dates

    Hi,
    I am trying to create an expense tracker for personal use. I will be recording my transactions on one table (Transaction Tracker) Fields include, Date of Transaction, Store, Category, Amount and summing them on another sheet (Pay Day) if the transaction on Transaction Tracker fell between the dates on Pay Day. I'd like this to be dynamic, as I will be using a form to quickly record my transactions.

  2. #2
    Registered User
    Join Date
    08-26-2020
    Location
    Hong Kong
    MS-Off Ver
    Office 19
    Posts
    3

    Re: Return Value if date in a range of cells falls between two dates

    I guess you could use VLOOKUP.
    VLOOKUP allows you to combine two sets of data on different spreadsheets into a single dataset. So basically, you set up a page for your PAY DAY (unique identifier) and another page for your TRANSACTION TRACKER (corresponding info). Then, VLOOKUP will help you spot the transaction on your pay day and list it out specifically.
    You search "Excel for Marketers #8 | How to use VLOOKUP to find and combine data" on youtube for how to use VLOOKUP by scenario.

+ 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. If date falls between two dates then return true
    By Anarchus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2017, 02:05 AM
  2. [SOLVED] VLOOKUP to Return Value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-23-2016, 12:38 PM
  3. VLOOKUP to return value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2016, 11:49 AM
  4. VLOOKUP to return value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2016, 11:48 AM
  5. HELP: Return a value with a date that falls between two other dates
    By hionman in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-18-2014, 08:01 AM
  6. [SOLVED] Looking for formula to return a date that falls between 2 dates
    By cobo1981 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-13-2014, 01:12 PM
  7. [SOLVED] Return value in X if date in Y falls between two dates - Help!
    By nephilim3uk in forum Excel General
    Replies: 4
    Last Post: 07-08-2012, 10:13 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