![]() |
#1
|
|||
|
|||
![]()
Hi
I am struggling with a DateDif function. I want to be able to identify those tasks that are scheduled to finish within 3 days of the current date. Here is what I have tried so far: IIf(Date()-[Finish]>"0" And Date()-[Finish]<="3","TRUE","FALSE") IIf(DateDif("d",[Finish],Date())>"0" AND DateDif("d",[Finish],Date())<="3","TRUE","FALSE") However neither works. I am sure I am close but cant see the issue. Any help appreciated. Thanks Tony |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
![]() |
msheyworth | Excel | 2 | 03-28-2013 02:15 AM |
![]() |
teza2k06 | Excel | 3 | 02-06-2013 08:29 AM |
![]() |
caz46 | Excel | 7 | 01-12-2012 08:46 AM |
if function help | jim831 | Excel | 2 | 10-29-2010 07:06 PM |