Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TODAY() in an IF AND function
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,$BV13TODAY()),$CJ13,"") Thanks so much:) Jennifer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TODAY() in an IF AND function
$BV13TODAY() limits the results to only the values in column CJ that have a
future date in column BV. What exactly do you want? Tom "Jennifer E" wrote: 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,$BV13TODAY()),$CJ13,"") Thanks so much:) Jennifer |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
TODAY() in an IF AND function
If what you want is to return a value only if column C = column E and a date
(any date) has been entered into column BV, then this formula might work for you: =IF(AND($C13=$B$13,isnumber($BV13)),$CJ13,"") or =IF(AND($C13=$B13,isnumber($BV13)),$CJ13,"") Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I use the TODAY() FUNCTION | New Users to Excel | |||
I'm using the =today() function but I'm getting ##### | Excel Worksheet Functions | |||
Today Function | New Users to Excel | |||
Today() & Now() function | Excel Worksheet Functions | |||
Can you do a function like =TODAY() PLUS 1? | Excel Worksheet Functions |