Results 1 to 8 of 8

Formula to check if a date falls within a date range, then returns a corresponding cell

Threaded View

  1. #8
    Registered User
    Join Date
    07-14-2017
    Location
    New York
    MS-Off Ver
    365
    Posts
    4

    Re: Formula to check if a date falls within a date range, then returns a corresponding cel

    I'm also learning the index and match functions.
    I'm trying to build a formula that searches expenses by date and returns the sum of values only during that month.
    This way I can have an endless expenses sheet and my monthly P&L searches for expenses that only occurred during that month.
    I have attached sample data. This same formula could ultimately be used for income too.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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