+ Reply to Thread
Results 1 to 4 of 4

When one of the partners dies marriage date must stop

  1. #1
    Registered User
    Join Date
    02-19-2018
    Location
    Netherlands
    MS-Off Ver
    Office 2007 for Home and Students (nl)
    Posts
    8

    When one of the partners dies marriage date must stop

    Hello.
    I work with Excel 2007 and I want to transfer addresses from Word to Excel. I have made a model but only one thing is not working properly yet.
    We have a church and civil marriage. See C41 and C44. But the date / counter must stop when one of the partners dies. If C18 or C39 is entered, the counter must stop in C41 and C44. Can a forum member change the formulas in the example and upload again so that it works correctly. Thanks in advance.

    Hallo.
    Ik werk met Excel 2007 Nederlandse versie en wil adressen overzetten van Word naar Excel. Ik heb een model gemaakt maar alleen één ding werkt nog niet goed.
    We hebben een kerkelijk en burgerlijk huwelijk. Zie C41 en C44. Maar de datum/teller moet stoppen wanneer één van de partners overlijdt. Als C18 of C39 is ingevuld moet de teller stoppen in C41 en C44. Kan een forumlid de formules aanpassen in het voorbeeld en weer uploaden opdat het wel goed werkt. Bij voorbaat dank. Ik heb onvoldoende kennis van Excel om afzonderlijke formules aan te passen ik moet dan exact weten welke formule in welke cel moet staan. Vandaar mijn verzoek om het document gecorrigeerd te uploaden.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: When one of the partners dies marriage date must stop

    Try this:

    =IF(AND(C$18="",C$39=""),DATEDIF(C41,TODAY(),"y"),DATEDIF(C41,MIN(C$18,C$39),"y"))

    you will need ; and not , in your formula...
    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.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-19-2018
    Location
    Netherlands
    MS-Off Ver
    Office 2007 for Home and Students (nl)
    Posts
    8

    Re: When one of the partners dies marriage date must stop

    @Glenn
    Fantastic your help. Now I can continue and fill in the first addresses. Thank you for uploading the example. Thank you very much.
    Senso

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: When one of the partners dies marriage date must stop

    You're welcome.



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

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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. Gale Shapley matching (Stable Marriage problem)
    By tshobe in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-12-2019, 04:38 AM
  2. Excel Dies when I copy / Paste Group Box (Form Control) manually or with VBA
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 04:50 PM
  3. Rotating List of Partners Automatically
    By tommygoesha in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-30-2016, 05:59 PM
  4. 40 years of marriage...
    By TMS in forum The Water Cooler
    Replies: 21
    Last Post: 04-08-2014, 01:56 AM
  5. Ranking Potential Business Partners
    By lukeaf in forum Excel General
    Replies: 3
    Last Post: 08-21-2012, 04:37 PM
  6. Count Partners Played With Others in Foursome
    By MarvinP in forum Excel General
    Replies: 1
    Last Post: 07-10-2011, 12:37 PM
  7. Marriage of two formulas
    By emerald_dragonfly in forum Excel General
    Replies: 2
    Last Post: 07-04-2005, 10:05 AM

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