=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

It's still not clear, but you can shorten it a bit and no need to use "0"

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

will return negative if A4 is greater than C6 and Current if between 0 - 14
but what happens if C6-A4 is greater than 14, not possible?

Regards,

Peo sjoblom



"techiemom60" wrote:


=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

Thanks for the help and yes, if it is more than 14, or a negative
number, it just needs to display that number.


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