how do i calculate age in term of years, months, days－software｜痞客邦

Jul 16 Mon 2007 20:38
how do i calculate age in term of years, months, days

close

how do i calculate age in term of years, months, days

put =TODAY() in A1
put your birthday in B1
and put

=DATEDIF(B1,A1,quot;yquot;) amp; quot; years, quot; amp; DATEDIF(B1,A1,quot;ymquot;) amp; quot; months, quot; amp;
DATEDIF(B1,A1,quot;mdquot;) amp; quot; daysquot;

in C1
--
Gary''s Studentquot;shanquot; wrote:

gt; how do i calculate age in term of years, months, days

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Solver solution hessian
此分類下一篇： Determine a cell's width and enter it in the cell
上一篇： Conditional formatting: alternate shading PLUS red for 0 values
下一篇： How do I identify all the non-paying customers from A/R workseet?

歷史上的今天

2007: dynamic charts
2007: why does sorting change a scatter plot graph?
2007: Linked Check Boxes
2007: What is an expert?
2007: Query, copy amp; paste
2007: A Cell linked between 2ExcelFiles, changes not seen in IE(inweb)
2007: Importing information from 2 workbooks into a 3rd one
2007: Comparing ranges:
2007: i want to open file office word from my mobile communicator 9300i
2007: To allow edit of particular rows and protect other rows from editi
2007: How to print 15 embeded charts on two sheets at once?
2007: INDEX and MATCH in one formula...
2007: shrink to fit and wrap text
2007: test
2007: Remove weekends from a stock chart
2007: Select Column
2007: XIRR and negative IRRs
2007: Spell check: advise and advice are used in the wrong context.
2007: Allow delete/insert cells to del/insrt highlighted rows/columns
2007: Excel graph
2007: Print Preview
2007: transpose data
2007: Is it possible to import external data into existing pivote table
2007: The above is an excel question
2007: Splash Screen Startup
2007: Preserving Cell Height and column width
2007: Dollar Ranges
2007: number lt; 0 = 0
2007: How to keep one column or row static while others move?
2007: Trying to automatically update...I keep getting shuttled...
2007: Last days for Early Bird Registration
2007: Calendar Control
2007: How do I get more columns in a pivot table?
2007: excel says folder is read only and cannot save
2007: Protected cells and grouping
2007: Printing running totals automatically
2007: Look At Two Dates
2007: A formula enquiry; (screenshots included)
2007: SUBTOTAL
2007: How do you transfer Labels in Word to Excel?
2007: Automatic List Generation
2007: Combining Row Contents!
2007: Less than/ Greater than logic flipped
2007: COUNTIF FORMULAS
2007: Applying auto-filter with large number of rows
2007: No color in Excel
2007: How to remove Subtotals
2007: COMBO BOX
2007: Excel copy formulas using non contiguous range
2007: Round/Ceiling on an IF function returning numerical value or text
2007: is it possible to recover an unsaved excel file that was x'd out
2007: Stripping text before a number (alpha or numeric)
2007: sumproduct
2007: Create custom text format?
2007: Offset function with nested match function not finding host ss.
2007: Countif with range name
2007: Q-q plot in Excel
2007: How to insert rows after each row of data (800 rows)?
2007: Macro to convert hyperlinks to text
2007: How can I run a spreasheet over range of input data ?
2007: Graph Question
2007: Countdown by Date
2007: hiding rows with a formula
2007: Automatic Bookmark
2007: Can function in one cell change value or function in another cell?
2007: Custom Format Cell
2007: Disable SelectionChange Event
2007: info
2007: Copy and Paste Macros
2007: Sub range from a range
2007: Conditional Sum problem
2007: How or can you link combo boxes in excel
2007: Filters
2007: merge two excel documents
2007: What function to determine the second small integer from a list?
2007: Why does A8 come up in military time?
2007: Blank (empty) cell always equal to 0??
2007: help needed
2007: Double lookup formula
2007: Please help a newbie with an excel vba macro relating to comments.
2007: Comparing Data
2007: Saving a sheet as a separate file
2007: Date Format
2007: How do I repeat rows at the top of specific pages (Excel)?
2007: calculate elapsed time between dates and times
2007: Improve Excel Help Text
2007: When running a SAP report Excel will only display results if Excel isn't already open
2007: searching a range for a sum...
2007: Keeping the format when referencing cells?
2007: How do I format a cell, so the user must use a user calendar?
2007: I need a formula!!Ahhhh!
2007: Vlookup help
2007: Microsoft request for slow-calculating workbooks
2007: Dates
2007: Selecting multiple columns for subtotals
2007: Getting values from columns into one cell
2007: =If
2007: Combine and sort
2007: Insert New Rows based on COUNTA()
2007: is there a problem with hyperlink in excel 2003

留言列表

站方公告

活動快報

newdirect

看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)