M
Michell Major
Elegant formula help needed. the 4 cells concerned are:
Date received, Date Claimed, storage start date and Elapsed days. Where: if
the goods are claimed in less than 24 hours NO elapsed days and no storage
date show. If > than 1 day then storage date starts as Date Received +1and
elapsed days begin. Storage chard=ges are driven by elapsed time.
This formula of mine doesn't work and is to clumsy anyway.
=IF(K5-J5<=1,"",IF(K5-J5>1,J5+1))
Many thanks
Date received, Date Claimed, storage start date and Elapsed days. Where: if
the goods are claimed in less than 24 hours NO elapsed days and no storage
date show. If > than 1 day then storage date starts as Date Received +1and
elapsed days begin. Storage chard=ges are driven by elapsed time.
This formula of mine doesn't work and is to clumsy anyway.
=IF(K5-J5<=1,"",IF(K5-J5>1,J5+1))
Many thanks