help with range lookup and date criteria

  • Thread starter Thread starter James Spalding
  • Start date Start date
J

James Spalding

Hello, I have a list of doctors (column A) that are each on-cal
through a number of days. My argument is: if the date value of B1 an
C1 is within the current date, then repeat the value of A1
 
hi, James !
... a list of doctors (column A) that are each on-call through a number of days.
... argument is: if the date value of B1 and C1 is within the current date, then repeat the value of A1.
Click to expand...

assumming 'B1' is a 'valid' date_data [the date when you called 'the doctor' ?]
and 'C1' are n_days 'after' [he asked you to call-back on ?]
op1: consider a conditional format to 'A1' ?... formula: =(b1+c1)=today()
op2: you want to repeat the doctor's name [a1]... =if((b1+c1)=today(),a1,"")
op3: too many cells with conditional-if functions ?... =choose(1+((b1+c1)=today()),"",a1)

hth,
hector.
 
Back
Top