Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-14-2014, 01:26 AM
OTPM OTPM is offline Using DateDif Function Windows 7 32bit Using DateDif Function Office 2010 32bit
Expert
Using DateDif Function
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
 



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
Using DateDif Function IF function msheyworth Excel 2 03-28-2013 02:15 AM
Using DateDif Function Sum Function teza2k06 Excel 3 02-06-2013 08:29 AM
Using DateDif Function 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft