• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    Calculating Dates in a Range

    Correction to my response to Luke... the cell was displaying as a date. Fixed that/changed to Number and it now shows 1 ;) What about the 30-60, 60-90, etc. Sorry, I'm pretty new at intricate formulas. My other sheet is laid out as follows: Cell A1: TODAY() Cell A2: 11/20/2012 Cell A3...
  2. V

    Calculating Dates in a Range

    I've gotten this to work in a different sheet using a cell for TODAY() and a cell for calculations of each date, but in that case, I'm only counting one record at a time. In this new sheet, i'm trying to count the number of xx in a range.
  3. V

    Calculating Dates in a Range

    jason, sorry, but I'm not familiar with using 'column' in a formula.. ?
  4. V

    Calculating Dates in a Range

    Luke, what does COLUMN(A$1)represent in your formula? When I use that formula as is... the result is "1/1"..
  5. V

    Calculating Dates in a Range

    I'm trying to come up with a formula to calculate # of days passed from a range of cells... Example: Cells D125:AD125 contain 2 dates; 11/20/2012 (in D125) and 1/3/2013 (in M125). I want to automatically calculate the age of each and count them to display how many are <30 days, how many are...
Back
Top