• 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. J

    How to have a date range bring back a value... Help

    Thanks Fred, but I am not sure I completely understand your formula. I did get it to work by putting in a table on a seperate sheet and using the formula below: =VLOOKUP($D$8,$B$4:$D$6,3,TRUE) D8 is my date, B is range 1 (first date for each quarter), C is range 2 (last date of each...
  2. J

    How to have a date range bring back a value... Help

    Hello, I am trying to creat a formula in which a value is brought back depending on a date range. For example, if a date listed in the workbook is between January 1 2011 to March 31 2011, I would want it to bring back Quarter 1, Quarter 2 if it is inbeteen the dates of April 1 and June 30...
Back
Top