compare 2 dates by 3 working days

[joey24]

date in cell A1: DD/MM/YY
date in cell B1: DD/mm/YY

if cell B1 is greater than cell A1 by 3 working days. formula will show "exceeded", if within 3 working days, "ok"

 

[JackDanIce]

Try:

= IF ( A1 + 3 < B1 , " EXCEED " , " OK " )

Remove relevant spaces, having issues posting

 

[VoG]

Try

=IF(NETWORKDAYS(A1,B1)>=3,"Exceeded","OK")

 

[joey24]

thanks. can the cell be empty instead of "ok" when there is no dates/data in A1 and B1?

 

[VoG]

Try

=IF(OR(A1="",B1=""),"",IF(NETWORKDAYS(A1,B1)>=3,"Exceeded","OK"))