how to convert 12/10/1970 to years/months/days
I work in a prison. Inmates can apply for pre-release when they have half their minimum sentence served. For example 2 years 6 months. They would have to serve 1 year 3 months. I use this formula =DATE(YEAR(A1)-A5,MONTH(A1)-B5,DAY(A1)-B6) where A1 is half the years, B5 is half the months, and B6 is half the days. The problem is when an inmate is sentenced to a minimum of 3 years and 3 months. The latter formula will not calculate 1.5 years or 1.5 months. It rounds up. What I would like to do is covert the 1.5 years to months and the 1.5 months to days.
I am sure this is pretty simple, but I can't seem to figure it out. I have this number that I want to convert in years, months, days format. What formula to use to get the number 505 converted to that. It is not the difference between two dates, so I can't use dated if.
I want to convert the number of days calculated into the number of months, days and years
Cell A1 = February 18 2007
Cell A2 = November 20 2011
If I am going to subtract A2 to A1, the result in A3 must be in days.
My DOB is 2-Feb-1970. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.
How can I do this in Excel?
I took the difference by putting the two dates in two cells and took the difference. But it is not working,
on the ff:
Using the formula =Today () as a basis, how can I determine the number of Years / Months / Days a certain batch have already rendered that will change in a daily basis.
Attached is a sample template for your reference.
Related Applications & Scripts
This is a simple script to calculate the difference between two dates and express it in years, months and days. Use as in: "my age is 40 years, 2 month and 17 days old"
Feel free to use this script for whatever you want.
Convert Your Catalogs, Brochures, Annual Reports and Other Documents Into a Flash Page Flip Within Minutes!
Convert PDF files to Flash Flip Book Within Minutes. Blow your readers away by improving their experience with this exciting way of digital publishing! Created within minutes & one-time resell rights.
17,000+ businesses worldwide use Instant Flipbook to enhance their static PDF's and publish a dynamic flipbook for themselves or their clients. In the 3+ years we're operating, we converted more than 1.5 million flip book pages for our clients.
Calendar components comes in 2 different sizes.(590370 and 376400) Calendar has 2 different days layout and supports unlimited events per day.
- Every day can have its own color
- Each day can have unlimited amount of events
- Events text can be HTML /(external)CSS formatted
- Calendar can be navigated through months and years
- Calendar supports Monday 2 Sunday and Sunday 2 Saturday layout
- Events can be automaticaly selected
- All data editable through XML is well documented
CCalendar is a calendar applet. You can use it as a real calendar choosing the global appearence and the photo you want to show.
You can use it as a help for you site's user to enter date in a form field. CCalendar support multilanguage for days and months, the choice of the first day of the week and adds schedule possibility. CCalendar allows you to link event to the days.