Using DateDif Function

OTPM · #1 03-17-2014, 02:17 AM

Hi Julie

Thanks for the feedback. Unfortunately this formula does not appear to work. For example I have a task that is due to finish on 19 March and it is not being flagged at all.

Edit: Sorted - needed the True and False in quotes then it works fine.

Thanks Julie.

Tony

JulieS · #2 03-17-2014, 05:16 AM

Great. Glad you have it worked out. I think when I tested I just saw the -1 and 0 and forgot to switch it out.

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