Results 1 to 14 of 14

Calculate birthday and age as if there were 112 days in a year

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2014
    Location
    Bombarral, Portugal
    MS-Off Ver
    2003
    Posts
    13

    Calculate birthday and age as if there were 112 days in a year

    Hi,

    I have Excel 2003,

    I'm having trouble with a formula of calculating age from a specific date.

    But first I'd like to know a formula to get to a birthdate, using the same 112 days in a year.

    I have this:
    =DATE(YEAR(O3)/112;MONTH(O3);DAY(O3))
    but it shows me back absurd dates, and I need this to be accurate, since I need this cell to get to this, which I'm not sure if it is well built as well:
    =INT((TODAY()-N3)/112) &" years and "& DAY(HOJE()-N3) &" days"
    O3= Next birthday
    N3= Birthdate

    Can anyone help?
    Last edited by Deep_Shadow; 12-11-2014 at 03:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate age if there were 112 days in a year
    By army in forum Excel General
    Replies: 7
    Last Post: 12-09-2014, 04:59 PM
  2. Calculate amount of days per year within range
    By constructionbart in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2014, 05:24 AM
  3. Calculate points for year based on last 180 days
    By Diogie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2013, 04:01 PM
  4. Convert a multiple year list of 365 days/year into an equivalent of 360 days/year
    By lobotomy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 05:39 PM
  5. Calculate Year Month and Days and Add them
    By lavan_joy in forum Excel General
    Replies: 8
    Last Post: 11-17-2010, 12:35 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