+ Reply to Thread
Results 1 to 4 of 4

excel formula to help my calculation from min dates of 3 dates cell ranges

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010
    Posts
    515

    excel formula to help my calculation from min dates of 3 dates cell ranges

    dear excel expert

    i have set of 3 dates A,B,C To calculate no of days from E column


    "If 1St Date Greater Than Actend Then Calculate Move To 2Nd Date
    If 2Nd Date Is Greater Than Actend Then Calcualte Move To 3Rd Date
    If 3Rd Greater Than Actend....Then Result All Date Greater Value"


    find the attachment!!! help on this
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: excel formula to help my calculation from min dates of 3 dates cell ranges

    As a start, you can use this formula
    Please Login or Register  to view this content.
    It gets more complicated when you have blanks. You have to start putting in a test to see if the cell is blank. You would have to put this into each cell and if it's blank, put in the other tests as the false condition. (A little more work that I want to get into)
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010
    Posts
    515

    Re: excel formula to help my calculation from min dates of 3 dates cell ranges

    Thanks Hectop Your formula works perfectly!!! Thanks for being time spent to my post!!!

  4. #4
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: excel formula to help my calculation from min dates of 3 dates cell ranges

    You're welcome.
    Shameless plug - if you haven't please add to my reputation by clicking on the link below my post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Check dates in range either same dates or different dates by formula
    By breadwinner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2013, 07:42 AM
  2. Formula to find dates that fall in several ranges
    By samcdavies in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2013, 11:20 AM
  3. Replies: 3
    Last Post: 06-02-2008, 06:28 PM
  4. Compare dates to ranges of dates
    By Santed593 in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 1
    Last Post: 08-05-2005, 12:22 PM
  5. Formula that will count between dates ranges
    By jbsand1001 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2005, 04:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1