How to update a cell if a specific date is included in a date rang

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope I can explain my problem:
These are my columns:

"Start" "End" "Start", "End " "License"
"01/1/06","02/1/06",....."12/1/10"
2/1/06 2/28/06 12/1/10 12/31/10 150 150
150
3/1/06 3/31/06 200
1/1/07 6/30/07 100
4/1/07 9/30/07 75
. . .
. . .
I need to look at the date on the columns and compare it to Start date & End
Date. If the column date is between these ranges, copy the corresponding
license amount under than date column; if not leave it blank.(like the sample
above).
I have been trying different ways with IF( ) but so far no luck. Thanks.
 
I'm not following your question. Can you give a SPECIFIC example, with
start and end dates that you apparently enter and the desired result.
 
Barb,

Thank you so much for taking the time to check on my problem.
Fortunately, after several attempts of testing with function combinations, I
came up with the answer to my own question. Basically, what I was looking for
was for some kind of BETWEEN function to check if a specific date was in 4
different date ranges in the same row. As far as I know, there is no BETWEEN
function in Excel.
I ended up creating an equivalent by combining IF, OR & AND. I performed a
variety of tests and it work as I wanted it. In summary, it looks something
like this:

=IF(OR(TRUE),$$$, " ")

If the OR function evaluates to TRUE, display license $$$, FALSE display
blank.
What was making it difficult for me was the evaluation of the 4 logical
conditions inside the OR function (That's where I used the AND).

Thanks again.

Miguel Gavidia
 
Back
Top