Between Function???

[mrowe]

Is there such a thing?

I've got a problem where I need to populate certain cells based on number of days old.

I've started by using the datedif() function which is fine, but I need to be able to say if the day value is <30 then put the value in cell P2, if the day value is >31 but <60 put the value in Q1 and so on.

Any ideas?
Matt

[Ricky Morris]

On 2002-05-21 09:34, mrowe wrote:
Is there such a thing?

I've got a problem where I need to populate certain cells based on number of days old.

I've started by using the datedif() function which is fine, but I need to be able to say if the day value is <30 then put the value in cell P2, if the day value is >31 but <60 put the value in Q1 and so on.

Any ideas?
Matt

in P1 do:
IF(A1<30,VALUE,"")
in Q1 do:
IF(AND(A1>30,A1<60),VALUE,"")
in R1 do:
IF(AND(A1>60,A1<90),VALUE,"")
...
...