Date backward question

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Date backward question

  1. #1
    Board Regular
    Join Date
    Sep 2003
    Posts
    486
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Date backward question

     
    I have been asked to set up an Excel chart for our local cemetery as a free favor for a friend.
    A lot of the stones have a date died but no date born but they do have the
    years, months, days lived.
    Can something be set up to work a date backwards?
    Example - Died - 7-10-1879 (this could also go from 1700 to 1800 or 1800 to 1900 or 1900 to 2000)
    Lived 23 Y, 4 M, 1 D

    This would work back to (I think) 3-9-1853 date of birth.

    We will have two Excel sheets, one with the plot layout (I am doing stone by stone location)
    and the other one
    being a register having the last & first name, Date born (this the part I don't have when they just have the lived data on the stone) and I need your help with., Date died and any other data that was on the stone.

    Thank you for your help.

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,557
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Date backward question

    Surprisingly this has been asked before, with the exact same sample dates !

    http://www.mrexcel.com/forum/excel-q...ate-birth.html

    Make sure you check out the addin in post #5
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Sep 2003
    Posts
    486
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date backward question

    That was odd.

    I did not think it would have been asked either.
    He must have been doing the same thing I am.

    Thank you for your help.

  4. #4
    Board Regular
    Join Date
    Sep 2003
    Posts
    486
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date backward question

    Michael M - Thank you for your reply.
    I tried the formula and I am doing something wrong and I don't know what it is.
    Can you tell me what I am messing up.

    -------B2-------------C2--------------D2---------------E2----------------F2-----------
    ----Born-------------Died-----------Years------------Months-----------Days---------
    -------------------7-10-1879-------23----------------4------------------1-----------


    In cell B2 I have the following formula
    XDATE(xdateYEAR(C2)-D2,xdateMONTH(C2)-E2,xdateDAY(C2)-F2)

    Thank you for your help.

  5. #5
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,557
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Date backward question

    What is the issue ?
    Did you download and install and activate the addin ?
    Are you getting an error ?
    Are you getting an incorrect answer ?
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  6. #6
    Board Regular
    Join Date
    Sep 2003
    Posts
    486
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date backward question

    Michael M - Thank you for your reply.

    I did download the file and the error I see is #NAME?

    I am sorry, I should have been more clear in my last posting.

    How can I tell if the file download correctly.

    Thank you for your help.

  7. #7
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,557
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Date backward question

    Check to see if it is in your Addins list.
    If you have 2007 or higher, there will be a menu tab, and you can also check by going to the home button.
    Select addins, and see if it one of the active addins
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  8. #8
    Board Regular
    Join Date
    Sep 2003
    Posts
    486
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date backward question

    Michael M - Thank you for your reply.

    I looked at the Add-Ins section and XDate does not show up.
    I downloaded again and it put the file into
    C:\Program Files (x86)\xdate

    Is that the correct place?

    Thjank you for your help.

  9. #9
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,557
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Date backward question

    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  10. #10
    Board Regular
    Join Date
    Sep 2003
    Posts
    486
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date backward question

      
    Michael M - Thank you for your reply.

    Thank you for valuable information, I never knew how to do that.
    I will copy that and save it.

    I followed the instructions and it's works perfect.

    Thank you so very much all of your help.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com