+ Reply to Thread
Results 1 to 3 of 3

Date issues

  1. #1
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Date issues

    I have 2 issues I am struggling with
    1. In column A I have a person date of birth 1971/06/01. In column B I have "=today()", which shows 2009/06/01. In column C I have "=B1-A1", with format "yy" to display the age, but 1 year less is shown. Only from tomorrow is the age correct. How do I fix the function in Colomn C

    2. The same file. If you change the format to "ddmm", both column A and B will show 0106, and in column D "=IF(A1=B1,1,0)", a "0" is displayed. How do I fix to show "1" in column D

    Thanks
    Last edited by CobraLAD; 06-01-2009 at 05:28 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Date issues

    Use DATEDIF

    =DATEDIF(A1,B1,"y") or =DATEDIF(A1,TODAY(),"y")

    see: http://www.cpearson.com/excel/datedif.htm

  3. #3
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Re: Date issues

    thanks DonkeyOte. It works

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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