Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Age calculation in Excel
 
Posts: n/a
Default calculate childs age Excel

I am trying to build a Excel spread sheet and I want to calculate the childs
age starting at 2 weeks of age. Then get month age and then year age.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Take a look at =datedif().

Chip Pearson has very nice instructions at:
http://www.cpearson.com/excel/datedif.htm



Age calculation in Excel wrote:

I am trying to build a Excel spread sheet and I want to calculate the childs
age starting at 2 weeks of age. Then get month age and then year age.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to calculate in Excel sheet eg. add or divide any thing and i. Suku New Users to Excel 1 February 16th 05 12:53 AM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel: Is there a way to calculate the date as week of month? debra adams Excel Discussion (Misc queries) 2 January 3rd 05 09:39 PM
How to calculate the data in excel 2002 including only the last 9. TylerMaricich Excel Worksheet Functions 6 November 8th 04 07:27 AM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"