in excel how to calculate no. of years, months & days from no. of days?
143192
Here's one way... there may be others....\n\nMake column A the "input" column (where you type in the # of days).  Make column B, C, and D "output" columns which displays the # of years, months, and days respectively.  Input the following formulas:\n\nCell B2:  =TRUNC(A2/365)\nCell C2:  =TRUNC((A2-(B2*365))/30)\nCell D2:  =MOD((A2-(B2*365)),30)\n\nHope this is what you are looking for...
792640
14.   7 for non leap years and 7 for leap years
206954
Excel stores dates and times in days.  If you subtract one time from another, the result will be in days.  Multiply by 24 to convert to hours.\n\nTo display tenths of an hour, format the cells to display tenths.\n\nTo always round up, add 0.05 hour.\n\nFor example, an employee starts work on March 12, 2006 at 8:05 and punches out at 5:11.  When you subtract the start time from the end time, you get 0.3796 days.  To get hours, multiply by 24: 9.11 hour.  To round up, add 0.05 hour: 9.16 hour rounds to 9.2 hour.
61805
try using this site. its a tutorial. http://www.usd.edu/trio/tut/excel/
829436
Just add an extra column which extracts only the month and the day from the date column. Let's suppose that the column containing dates is column A, staring with row 2. In the extra column, on the second row, the formula will be:\n=TEXT(A2, "mmdd"). Copy the formula downwards, for all the rows.All you have to do then is to sort by that extra column
109867
Here is a poem to help you learn how many days in a month\n\nThirty days hath September,\nApril, June, and November;\nAll the rest have thirty-one,\nExcepting February alone,\nWhich hath but twenty-eight, in fine,\nTill Leap Year gives it twenty-nine.
225407
TWO WAYS TO REMEMBER HOW MANY DAYS IN A MONTH\n\nA RHYME:\n30 days has September, APRIL, June and November.\nAll the rest have 31 except February alone which has 28 or 29 on a leap year.\n\nA STRANGE COINCIDENCE\nClench your fists and put your knuckles together side my side. The first knuckle on the left of your left hand is January, then moving to the right there is a dip, this is February, then there is the next knuckle, March, etc. until you get to December on the middle of your right hand. All the knuckles are 31 days and all the dips are 30 (except February, which is an exception, as above)
167562
Number of years in ( Today's date- your birthdate)
785036
month/day/year(last 2 digits)
320999
Write into the cell 49,417*1.077^x\nx is how many months
1142411
Sounds like VLOOKUP is what you are looking for.\n\nFor example, I have will have a sheet that has a list of months in one column and in the second column I have the group that is responsible for something in the corresponding month.\n\n(ignore the dashes, they are for spacing only)\n----A------B  \n1--Jan--Team 1\n2--Feb--Team 2\n3--Mar--Team 3\n\nNow you would write the VLOOKUP formula:\nLets put =VLOOKUP(C1,A1:B12,2,) in C2\nif you typed Feb in C1, the formula in C2 will return "Team 2"
697117
Subtract the cells and format it as numeric
401014
What you need to do is enter the beginning time and ending time in 2 different cells.  Highlight all the cells that include time and click Format in the standard toolbar.  Then click Cells, when the window opens select the Format tab and chose the Time option in the right.   Select the time format that works best for you and click OK.  Then type the formula and make sure that that cell is also formatted as a time type cell.  If you are just calculating how long people are working a simple B-A forum la would help.
80373
I'd like to agree with the first answer, because it\n*does* take leap years into account (that's why\nit suggests that each year is 365.25 days).\n\nThe only thing I can add is that I did a google search\non the "length of a year", and it suggests using\nthe following value (which appears to subtract out\nthe 3 out of 4 century years which are NOT leap years\neven though the year is divisible by 4):\n\n365.242199 days\n\nThus another value for hours is: 130*24*265.24199
1185100
let me calculate my age 1+1+1+1+1 i am confused
226966
take the date they were born and subtract it  from teh current date\n\n12/31/05 - 6/12/91 = 6 months, 19 days and 14 years
876511
not adding in for the extra partal days each year 31536000\n\nadding in for the extra partal days each year 31556926.08