Calculate age if there were 112 days in a year

**army** · 09-25-2011, 10:45 PM

Hi,
I'm having trouble with a formula of calculating age from a specific date.
I tried this formula =INT((date-birthdate)/112) but it's not exactly what I want.
I want that the age will show years & days (25 years and 77 days) and not years only.
It should be as if there were 112 days in a year.

Can anyone help?

**ConneXionLost** · 09-26-2011, 12:15 AM

Assuming the "date" is in cell A2, and the "birthdate" is in cell B2, try:

Please Login or Register  to view this content.

Cheers,

**army** · 09-26-2011, 12:28 AM

Originally Posted by ConneXionLost

Assuming the "date" is in cell A2, and the "birthdate" is in cell B2, try:

Please Login or Register  to view this content.

Cheers,

Works like a charm. Cheers.

**royUK** · 09-26-2011, 01:53 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

And please don't quote whole posts when replying

**Deep_Shadow** · 12-08-2014, 10:35 PM

Would need the same thing but for Excel 2003.

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

I have this:

Please Login or Register  to view this content.

but it shows me back absurd dates, and I need this to be accurate, since I need this cell to get to this:

Please Login or Register  to view this content.

O3= Next birthday
N3= Birth day

**ConneXionLost** · 12-09-2014, 02:35 PM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**Deep_Shadow** · 12-09-2014, 04:56 PM

I did, only to see it closed, because apparently the thread doesn't comply with Rule 5, as it is duplicate...

Seems some sort of a joke, really...

**alansidman** · 12-09-2014, 04:59 PM

Closed in error. Has been reopened.

Calculate age if there were 112 days in a year

LinkBack

Thread Tools

Rate This Thread

Display

Calculate age if there were 112 days in a year

Re: Calculate age if there were 112 days in a year

Re: Calculate age if there were 112 days in a year

Re: Calculate age if there were 112 days in a year

Re: Calculate age if there were 112 days in a year

Re: Calculate age if there were 112 days in a year

Re: Calculate age if there were 112 days in a year

Re: Calculate age if there were 112 days in a year

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions