date look up

0

I want to always use the current date and see if it is equal to and/or falls between 2 specifed dates and if so then I want it to post in my formula cell info from another designated cell.

I have tried the below and variations of it but to no avail

=IF(and(today()>=(3/24/19:3/29/19),'Course-Dates-Prices'!C11,""))

Answer
Discuss

Answers

0
Selected Answer

Hi there and welcome!

Dates are a pain in the butt! You have to do this to get Excel to see a date in a formula:

=DATEVALUE("3/24/19")

Change your formula to this and it should work:

=IF(AND(TODAY()>=DATEVALUE("3/24/19"),TODAY()<=DATEVALUE("3/29/19")),'Course-Dates-Prices'!C11,"")
Discuss

Discussion

Thanks Don for your answer. I coppied and pasted your formula and nothing happened so I went to evaluate formula and it sad RE-CAP!$A$2   not sure what that means, i will need further help.... please? 
kandrews (rep: 2) Mar 26, '19 at 2:47 pm
Sure, just edit your question and upload a sample workbook and it will be easier to see what's wrong and I can take a look at it.
don (rep: 1685) Mar 27, '19 at 5:05 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login