You are here: HomeExcelTutorials

# how to convert 12/10/1970 to years/months/days

## how to convert 12/10/1970 to years/months/days

Price: FREE

to covert 12/10/1970 to years/months/days

Visit publisher's web-site: how to convert 12/10/1970 to years/months/days

Category and Tags: ExcelTutorials :

## Related Tutorials

### Convert decimal to months

Free: Yes
Tags: Excel ›

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.

### How to convert a number to years, months, days?

Free: Yes
Tags: Excel › Functions

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.

### convert month days and years into days

Free: Yes
Tags: Excel ›

I want to convert the number of days calculated into the number of months, days and years
For example:
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.

### Date Difference

Free: Yes
Tags: Excel ›

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,

### How to compute Years / Months / Days?

Free: Yes
Tags: Excel ›

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

### Calculate Date Difference

Free: Yes
Tags: PHP › Excel Date and Time

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 PDF files to Flash Flip Book

Free: No

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.

### Smart XML Events Calendar

Free: No
Tags: Flash › Excel Calendars

Calendar components comes in 2 different sizes.(590370 and 376400) Calendar has 2 different days layout and supports unlimited events per day.
FEATURES :
- 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

### Ajax calendar class

Free: Yes
Tags: PHP › Excel Ajax Calendars

This class can be used to display month calendars browseable using AJAX. It can generate HTML and JavaScript to display a month calendar with links to browse the months using AJAX to avoid page reloading. The class can make given days be displayed as links to event pages. The browsing may be restricted to given dates. The months and week day names are customizable. The presentation details may be customized using CSS.

### Calendar applet

Free: Yes
Tags: Java › Excel Applets Calendars

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.