Results 1 to 5 of 5

Thread: Formulas (2003)

  1. #1
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formulas (2003)

    Hello everyone & Happy Spring!

    I am trying to add a formula in my excel spreadsheet that checks dates to ensure they are logical in a particular business process that I have. In my attachment, I would like to insert a formula which tells me if visit start dates are equal to or after visit end dates, if the submitted dates are equal to or after visit start dates, or if the visit start date is equal to or before the submitted date. The result can be shown in as a negative number, or just some type of indicator where I can look down the list and easily identify those rows which do not fit the criteria. The purpose is to ensure that someone is not submitting a document before the start date of that task, because it is illogical to have completed a document before the actual start date of that task (I hope this makes sense). Your help is really appreciated! :-)
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (2003)

    Does the attached do what you want? To se how it is done, select one of the cells and then click on "Conditional formatting" in the Format menu.
    Attached Files Attached Files
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (2003)

    Hi there! Thanks for sending this. Actually, I was hoping to note it somehow in the appropriate columns. For example, if the formula result was that the submitted date was before the visit start date, I would like to see some type of value in the column so that I can easily spot those that fall into that category. Is it possible to calculate, say, number of days that the value was before the visit start date?

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

    Re: Formulas (2003)

    See the attached version. I didn't put anything in column F, since the result would be the same as column E: if the submitted date is equal to or after the visit start date, the visit start date is by definition equal to or before the submitted date.
    Attached Files Attached Files

  5. #5
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (2003)

    That's it! That's what I was looking for! Thanks to you both for your quick assistance!! :-)

Posting Permissions

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