![]() |
|
#3
|
|||
|
|||
|
Hi Julie
Many thanks for your prompt response (yes I did spell the Function name wrong :-)). I ended up using this formula in the end but will also try your solution: IIf([Finish]>Date(),IIf([Finish]-Date()<=3,"TRUE","FALSE"),"NA") Edit: I modified your solution in an attempt to ignore those tasks that were complete but the edit does not work, any ideas? IIf([Status]="Complete","",IIf(DateDiff("d",[Finish],[Current Date])>0 And DateDiff("d",[Finish],[Current Date])<=3,True,False)) 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 |