Between Function

T

techiemom60

=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 th
difference in dates. if the date is between 0 and 14 days, it mus
say current, if it is anything other than that, or blank, it must show
the days negative.

Any assistance would be greatly appreciated.

Thanks in advance
 
P

Peo Sjoblom

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
 
T

techiemom60

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