Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Formula (2003)

    Howdy,
    I have done this before, brain cramp. I have a date ordered column, quantity ordered, date received, number of days between order and received. I want to put in the date ordered and the quantity and have the between days only show when a date received is entered.
    Sample is attached with explinations.
    Thanks again to everyone.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Formula (2003)

    Try this formula in E5 (and fill down as far as necessary):
    <code>
    =IF(OR(ISBLANK(A5),ISBLANK(C5)),"",C5-A5)
    </code>
    This only returns a number if both date ordered and date received are filled in.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •