date look up


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




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:


Change your formula to this and it should work:



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