Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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,""))

excel
MS Office Version: 140 32 bit
posted by: kandrews (rep: 2) on Sun Mar 24, 2019 at 1:07 pm
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,"")
posted by: don (rep: 1989) on Mon Mar 25, 2019 at 2:46 am
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: 1989) 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