View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michell Major Michell Major is offline
external usenet poster
 
Posts: 34
Default EXCEL 2003 Dates & elapsed time

Elegant formula help needed. the 4 cells concerned a

Date received, Date Claimed, storage start date and Elapsed days. Whe 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-J51,J5+1))

Many thanks