+ Reply to Thread
Results 1 to 2 of 2

Need to calculate a range of cells based on a date range

  1. #1
    Registered User
    Join Date
    06-02-2022
    Location
    Arizona
    MS-Off Ver
    Office 365
    Posts
    2

    Need to calculate a range of cells based on a date range

    Hello,

    I've attached a sample of the workbook to help understand what I am trying to achieve. I have a set of data in column C, a list of dates in column A, and would like to have a value returned in B5 based on the following criteria: Count if the date range in column A is less than 6 months from the current date. Any help would be greatly appreciated. Thank you!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-02-2022
    Location
    Arizona
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Need to calculate a range of cells based on a date range

    I've got it figured out! Formula below in case anybody else needs something like this.

    =SUMIFS(C:C, A:A, "<="&TODAY(), A:A, ">"&TODAY()-183)

+ 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. calculate % out of 100 based on date range.
    By Casper26 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-30-2020, 06:38 PM
  2. [SOLVED] Formula needed for add a range of cells based on date range and text in other cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-15-2020, 08:36 PM
  3. Calculate sums based on date range
    By konbanwa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2017, 02:42 PM
  4. Replies: 4
    Last Post: 02-06-2017, 10:20 PM
  5. [SOLVED] Calculate # days in week based on date range
    By Peelah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2016, 07:01 PM
  6. [SOLVED] Calculate based on date and time range
    By local1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-25-2015, 08:33 AM
  7. Calculate Effective Date based on Another Date Range
    By Alphabex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2015, 01:43 PM

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