Using DateDif Function

OTPM · #1 03-13-2014, 06:32 AM

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

Similar Threads
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
IF function	msheyworth	Excel	2	03-28-2013 02:15 AM
Sum Function	teza2k06	Excel	3	02-06-2013 08:29 AM
Help with DATEDIF Formula	caz46	Excel	7	01-12-2012 08:46 AM
if function help	jim831	Excel	2	10-29-2010 07:06 PM