J
Jennifer E
Hi,
I'm trying to create an IF AND Today() function. The difficulties I'm
having with this is that when I enter the TODAY() portion of the function the
result is the either the units that have scheduled a date, but the date is
both before and after TODAY(), or it's the units that have not scheduled a
date. I cannot get the result of the dates that have already occurred or
are equal to TODAY().
My current formula is:
=IF(AND($C13=$B$13,$BV13>TODAY()),$CJ13,"")
Thanks so much
Jennifer
I'm trying to create an IF AND Today() function. The difficulties I'm
having with this is that when I enter the TODAY() portion of the function the
result is the either the units that have scheduled a date, but the date is
both before and after TODAY(), or it's the units that have not scheduled a
date. I cannot get the result of the dates that have already occurred or
are equal to TODAY().
My current formula is:
=IF(AND($C13=$B$13,$BV13>TODAY()),$CJ13,"")
Thanks so much
Jennifer