=IF(ISBLANK(C6),"0",IF(($C6-$A$4)<=14,"Current",IF(($C6-$A$4)<14,$C6-$A$4)))

I have the above formula. I need the first <=14 to evaluate the
difference in dates. if the date is between 0 and 14 days, it must
say current, if it is anything other than that, or blank, it must shows
the days negative.

Any assistance would be greatly appreciated.

Thanks in advance.


--
techiemom60
------------------------------------------------------------------------
techiemom60's Profile: http://www.excelforum.com/member.php...o&userid=20124
View this thread: http://www.excelforum.com/showthread...hreadid=542238