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 |
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 |