Results 1 to 5 of 5

Thread: Birthday calculator spreadsheet in excel

  1. #1
    Join Date
    Jun 2011
    Posts
    101

    Birthday calculator spreadsheet in excel

    I am firm to make a spreadsheet that will show D.O.B. current age in days/ months/ years including number of days remaining until next birthday. Actually I am not good in remembering birthdays. I have tried but getting error like with the formula: '=DATEDIF(TODAY(),EDATE(C4,(YEAR(NOW())-YEAR(C4))*12),"d")' for '=TODAY()-C16' yields "00 Years 4 Month(s) 12 Days"

  2. #2
    Join Date
    May 2009
    Posts
    529

    Re: Birthday calculator spreadsheet in excel

    I can help you in this topic since I have tried it personally. You can get age in years, months and days with this formula in D4:

    Formula-

    You can get age in years, months and days with this formula in D4

    1. =DATEDIF(C4,TODAY(),"y")&" years "&DATEDIF(C4,TODAY(),"ym")&" months "&DATEDIF(C4,TODAY(),"md")&" days"


      and then days to next birthday
    2. =EDATE(C4,DATEDIF(C4,TODAY(),"y")*12+12)-TODAY()

  3. #3
    Join Date
    May 2009
    Posts
    543

    Re: Birthday calculator spreadsheet in excel

    If you still haven’t found any help try the below code. In the following code the EDATE adds number of months to a date. I will give you an example which I have used for a person of age 21 years and next year the person will be 22 years. For that the formula that I have used is:


    • =EDATE(Birthdate,Age*12+12)
    • You can calculate the age - DATEDIF(Birthdate,TODAY(),"y"). So now the formula becomes

      =EDATE(Birthdate,DATEDIF(Birthdate,TODAY(),"y")*12+12)
    • Now to calculate the number of days from today until that date we can just subtract TODAY() from the above, hence

      =EDATE(C4,DATEDIF(C4,TODAY(),"y")*12+12)-TODAY()

      Here the C4 contains the birth date.

  4. #4
    Join Date
    May 2009
    Posts
    511

    Re: Birthday calculator spreadsheet in excel

    If your above steps don’t work then try the below Formula. I am sure this might help or it might give you reference to apply. The EDATE function requires Analysis ToolPak to get installed. For that you have to go to Tools then go to addins after that tick on the "Analysis ToolPak" box following with click on OK.
    Press F9 to re-calculate formula

    • Use this Longer Formula:

      =DATE(YEAR(C4)+DATEDIF(C4,TODAY(),"y")+1,MONTH(C4),DAY(C4))-TODAY()

      Where the date of birth is in C4.

  5. #5
    Join Date
    May 2009
    Posts
    637

    Re: Birthday calculator spreadsheet in excel

    Try all the possible options you could. I can suggest you the following options for calculating birthdays.

    1. =DATEDIF(TODAY(),DATE(YEAR(TODAY())+(--(TEXT(C2,"mmdd"))<--(TEXT(TODAY(),"mmdd"))),MONTH(C2),DAY(C2)),"YD")

    2. =DATE(YEAR(C2)+DATEDIF(C2+1,TODAY(),"y")+1,MONTH(C2),DAY(C2))-TODAY()

    3. =EDATE(C2,DATEDIF(C2+1,TODAY(),"y")*12+12)-TODAY()

Similar Threads

  1. How can I make Birthday reminder in Excel
    By Choo-Kheng in forum Windows Software
    Replies: 6
    Last Post: 10-07-2011, 11:13 AM
  2. Can We Auto-Run Excel Spreadsheet.??
    By Dilbert in forum Windows Software
    Replies: 4
    Last Post: 02-01-2010, 09:09 PM
  3. add Checkbox in Ms Excel spreadsheet
    By Novino in forum Windows Software
    Replies: 4
    Last Post: 02-09-2009, 09:43 PM
  4. Importing Excel Spreadsheet
    By Theodore Long in forum Microsoft Project
    Replies: 3
    Last Post: 05-06-2009, 09:02 AM
  5. Corrupt spreadsheet in excel
    By Indrani in forum Windows Software
    Replies: 3
    Last Post: 06-05-2009, 03:12 PM

Tags for this Thread

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
  •  
Page generated in 1,711,700,732.24163 seconds with 17 queries