needing help on a date problem.

0

needing help on a date problem.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,""))

=IF(AND(TODAY()>=DATEVALUE("3/24/19"),TODAY()<=DATEVALUE("3/29/19")),'Course-Dates-Prices'!C11,"")
 look under the  recap tab and you will see where i am trying to put the formula.    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: 1616) Mar 27, '19 at 5:05 am
Answer
Discuss

Discussion

It seems to work just fine for me. I changed the dates to check and I don't see an issue. You can use this one to check for todays dates:
=IF(AND(TODAY()>=DATEVALUE("4/20/19"),TODAY()<=DATEVALUE("4/29/19")),'Course-Dates-Prices'!C11,"")
And sorry about late followups :P
don (rep: 1705) Apr 22, '19 at 3:06 pm
Add to Discussion


Answer the Question

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