| Method-1 : You can calculate a persons age based on their birthday and todays date. |
|||||||||||||||||||||||||||||||||||||||||
| The calculation uses the DATEDIF() function. | |||||||||||||||||||||||||||||||||||||||||
| The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000. | |||||||||||||||||||||||||||||||||||||||||
| (Makes you wonder what else Microsoft forgot to tell us!) | |||||||||||||||||||||||||||||||||||||||||
| Birth date : | 1-Jan-60 | ||||||||||||||||||||||||||||||||||||||||
| Years lived : | 53 | =DATEDIF(C8,TODAY(),"y") | |||||||||||||||||||||||||||||||||||||||
| and the months : | 1 | =DATEDIF(C8,TODAY(),"ym") | |||||||||||||||||||||||||||||||||||||||
| and the days : | 3 | =DATEDIF(C8,TODAY(),"md") | |||||||||||||||||||||||||||||||||||||||
| You can put this all together in one calculation, which creates a text version. | |||||||||||||||||||||||||||||||||||||||||
| Age is 53 Years, 1 Months and 3 Days | |||||||||||||||||||||||||||||||||||||||||
| ="Age is
"&DATEDIF(C8,TODAY(),"y")&" Years,
"&DATEDIF(C8,TODAY(),"ym")&" Months and
"&DATEDIF(C8,TODAY(),"md")&" Days" Method-2 :
|
|||||||||||||||||||||||||||||||||||||||||
Sabeen Zulfiqar Ali
Monday, 4 February 2013
Age Calculation
AutoSum Shortcut Key
| Instead of using the AutoSum button from the toolbar, | |||||
| you can press Alt and = to achieve the same result. | |||||
| Try it here : | |||||
| Move to a blank cell in the Total row or column, then press Alt and =. | |||||
| or | |||||
| Select a row, column or all cells and then press Alt and =. | |||||
| Jan | Feb | Mar | Total | ||
| North | 10 | 50 | 90 | ||
| South | 20 | 60 | 100 | ||
| East | 30 | 70 | 200 | ||
| West | 40 | 80 | 300 | ||
| Total | |||||
Saturday, 5 January 2013
What Is Textile Fiber?
1- The fundamental component used in making textile yarns and fabrics.
2- Fibres are fine substances with a high ratio of length to thickness.
3- It is defined as one of the delicate, hair portions of the tissues of a plant or animal or other substances that are very small in diameter in relation to there length. A fiber is a material which is several hundred times as long as its thick.
OR
Textile fiber has some characteristics which differ between fiber to Textile fiber. Textile fiber can be spun into a yarn or made into a fabric by various methods including weaving, knitting, braiding, felting, and twisting. The essential requirements for fibers to be spun into yarn include a length of at least 5 millimeters, flexibility, cohesiveness, and sufficient strength. Other important properties include elasticity, fineness, uniformity, durability, and luster.
.
.
2- Fibres are fine substances with a high ratio of length to thickness.
3- It is defined as one of the delicate, hair portions of the tissues of a plant or animal or other substances that are very small in diameter in relation to there length. A fiber is a material which is several hundred times as long as its thick.
OR
Textile fiber has some characteristics which differ between fiber to Textile fiber. Textile fiber can be spun into a yarn or made into a fabric by various methods including weaving, knitting, braiding, felting, and twisting. The essential requirements for fibers to be spun into yarn include a length of at least 5 millimeters, flexibility, cohesiveness, and sufficient strength. Other important properties include elasticity, fineness, uniformity, durability, and luster.
.
.
Thursday, 3 January 2013
What Is Textile ??
There are many words to explain “TEXTILE”, here are some short and sensible sentences to explain it.
• Anything that can be originated or generated from fiber is
called textile.
• In narrow sense fiber to fabric production is textile.
• In greater sense fiber to clothing/garment is textile.
.
.
• Anything that can be originated or generated from fiber is
called textile.
• In narrow sense fiber to fabric production is textile.
• In greater sense fiber to clothing/garment is textile.
.
.
Subscribe to:
Posts (Atom)