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