formula from a date in a different cell

[j4ymf]

Hello I'm trying to create a work sheet but im stuck on the formula


im trying to get my value from H10 which = 2
my cell my formula goes in is I10
my date is in I7
End date is in F10

can I create a formula thats in I10 that looks at a date in I7 and if its less than the date in F10 places a value from H10

hope this makes sense

thank you Jason

 

[j4ymf]

thank you joe4
my fault it works fantastic thank you

 

[j4ymf]

thank you very much for your help
it was my fault, a little tweak and it worked great

=IF(AND(J6 > $F$10, J6 < $G$10),$I$10,"")

 

[Joe4]

You are welcome.

 

[j4ymf]

Hello All
I was given this formula from Joe4 and it works fantastic and now I need to add a bit too it.
=IF(AND(AA6 >= $F$23, AA6 < $G$23),$I$23,"")

currently its looking between two dates but now I have been asked to add two dates can this be done?
I've tried guessing and I'm getting and argument error.

=IF(AND(AA6 >= $F$23, AA6 < $G$23),$I$23,AA6 >= K23, AA6 <L23),N23,"")

please advise
thank you jason

 

[Fluff]

Is this what you need
=IF(AND(AA6 >= $F$23, AA6 < $G$23),$I$23,IF(AND(AA6 >= $K$23, AA6 < $L$23),$N$23,""))

 

[j4ymf]

thank you Fluff, that's fantastic

 

[Fluff]

You're welcome & thanks for the feedback