Thread: Showing how much longer for a due date.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
oldchippy[_7_] oldchippy[_7_] is offline
external usenet poster
  
Posts: 1
Default Showing how much longer for a due date.

Hi,

If your delivered date is in A1,then something like this

=IF(TODAY()A1+30,"Out of Time","Days left "&A1+30-TODAY())


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=69451

Reply With QuoteReply With Quote