+ Reply to Thread
Results 1 to 8 of 8

# Of Days Since Last Contacted

  1. #1
    Registered User
    Join Date
    09-13-2017
    Location
    Los Angeles, California
    MS-Off Ver
    Office365
    Posts
    4

    # Of Days Since Last Contacted

    Thank you for taking the time to read this and to help. I'm looking for a formula that will help determine the # of days that have elapsed since a customer was last contacted. For illustration purposes, please look at the picture below.Screen Shot 2017-09-12 at 9.37.18 PM.png

    I hope this illustration helps as to what I am looking to accomplish. Any help would be greatly appreciate. Thanks in advance.
    Attached Images Attached Images

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: # Of Days Since Last Contacted

    Koko67 welcome to the forum.

    Try entering this in AM4 and fill down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: # Of Days Since Last Contacted

    AM4=MATCH(1,INDEX((AN4:AV4<>"")+0,0),0)-1
    OR
    =TODAY()-INDEX(AN$1:AV$1,MATCH(1,INDEX((AN4:AV4<>"")+0,0),0))-2

    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: # Of Days Since Last Contacted

    Similar to Siva's last formula.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-13-2017
    Location
    Los Angeles, California
    MS-Off Ver
    Office365
    Posts
    4
    Quote Originally Posted by FlameRetired View Post
    Koko67 welcome to the forum.

    Try entering this in AM4 and fill down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dude, to simply say that you're a *^%#%^* genius would be a gross understatement. But seriously, you're a rockstar and thank you for the quick reply. 🙏🏽

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: # Of Days Since Last Contacted

    You are welcome. Thank you for the feedback and generous comment.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  7. #7
    Registered User
    Join Date
    09-13-2017
    Location
    Los Angeles, California
    MS-Off Ver
    Office365
    Posts
    4

    Re: # Of Days Since Last Contacted

    Okay almost there. Thanks again for all the overwhelming amount of help... and to think, in such little time? Good to know that good & helpful people still exist out there. Okay so here goes:

    Screen Shot 2017-09-13 at 6.41.23 AM.png

  8. #8
    Registered User
    Join Date
    09-13-2017
    Location
    Los Angeles, California
    MS-Off Ver
    Office365
    Posts
    4

    Re: # Of Days Since Last Contacted

    ACTUALLY, I JUST FIGURED IT OUT.... created new column and just hid it. thank you again.

+ 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. [SOLVED] A number of days into weeks and days-How do you convert the decimal part of 0.571429
    By Robert Christie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-25-2020, 09:37 PM
  2. [SOLVED] Adding the correct number of working days to the chart, skipping off days
    By Vitalite in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-15-2017, 03:31 AM
  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. [SOLVED] Formula for Last Time Contacted
    By kalffiend in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 07-30-2015, 01:03 PM
  5. Replies: 0
    Last Post: 06-11-2015, 03:12 AM
  6. Replies: 4
    Last Post: 05-19-2014, 04:28 PM
  7. Work Schedule that calculates hours, lunches, days off and vacation days
    By tameronstarr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1