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

Testing for value between dates

D

djschwar

New Member
I saw an older post in which median is being used to test between values. I know dates are only values in Excel, but could someone help me with this?!


I have a table of service requests and I need to have a formula to identify in what period the SR falls. So example:


These are the results I need to show for each SR

Prior Period are SRs with dates of 12/1/11 through 3/31/12

Current Period are SRs with dates 4/1/12 through 5/31/12

Outside Range: All SRs not falling into those periods


I have a nested if statement using the 'and' function, but it's not working...and not elegant at all! Thanks Thanks Thanks!!!!
 
Welcome to Chandoo.org forums.


Assuming the date you want to test is in A1, write


=if(median(A1,"12/1/11","3/31/12")=A1,"Prior Period",if(median(A1,"4/1/12","5/31/12")=A1,"Current Period","Outside Range"))


Vist http://chandoo.org/wp/2010/06/24/between-formula-excel/ for more info on between formula.
 
That is fantastic! I have been "messing" around with this for well over two hours. Many many years ago in another life I was one answering questions on formulas and very complex macros in Excel...but that was before they even started using VB. But when you stop using a product except for the simplest of tasks, it's easy to forget.


I REALLY appreciate the help....now I have to take some time and understand it. :)


Dave
 
You must log in or register to reply here.
Back
Top