+ Reply to Thread
Results 1 to 3 of 3

Need help on calculating number of days between 2 days W.R.T different criterias

  1. 08-27-2019, 05:55 AM #1
    Vikramchetan
    Vikramchetan is offline
    Registered User
    Join Date
    03-18-2017
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    17

    Post Need help on calculating number of days between 2 days W.R.T different criterias

    I need help on calculating number of days between 2 dates by referring to different criteria's.

    In attached excel file I have updated "Arrival dates at my place" of 4 different ships. I need to calculate number of days each ship takes to "Arrive at my place".

    i.e. if Ship "A" arrives at my place on 1st August and again if she arrives on 3rd August I need a formula to calculate the number of days for every round voyage of Ship A and for all ships.


    Round Voyage.xlsx
    Reply With QuoteRegister To Reply
  2. 08-27-2019, 08:01 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Need help on calculating number of days between 2 days W.R.T different criterias

    ?? In L3, copied down:

    =IFERROR(E3-LOOKUP(2,1/($C$2:C2=C3),$E$2:E2),"")
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 08-27-2019, 08:16 AM #3
    maras_mak
    maras_mak is offline
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    536

    Re: Need help on calculating number of days between 2 days W.R.T different criterias

    Not sure I understand everything, but try something like this...
    L3 formula and copy down. 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,
    Maras.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating Years, Months, Week, Days, Hours, Minutes for Work Days between two dates
    By hecgroups in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-23-2019, 12:09 AM
  2. [SOLVED] How to calculate and return exact number of days in a month based on criterias
    By MyStix01 in forum Excel General
    Replies: 8
    Last Post: 05-16-2018, 01:00 PM
  3. [SOLVED] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  4. DAYS function: correctly calculating the number of days
    By dadpad in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-25-2015, 09:18 PM
  5. Calculating Market Days (excluding weekends, holidays) & short days between two dates/time
    By trw57 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-31-2014, 10:32 AM
  6. Calculating days in between 2 dates (which have after 14 days issued date)
    By husni in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2014, 06:40 AM
  7. Calculating time elapsed in days and count days within same range
    By michellem410 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-19-2008, 01:13 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1