bodmas ilt in maths Excel date and time arithmetic

Excel date and time arithmetic

There is a Web page all about dates and times in Excel. Very handy for projects on dates and elapsed time.

http://www.cpearson.com/excel/datetime.htm

Below are two ways of finding the age of someone on completed years. 
If date of birth as an Excel date is in cell A1, then
   
   =INT((NOW()-A1)/365.25)
   
   gives the age in completed years
Another method uses the dateif() function (avilable from Excel 5 but in help from Excel 2000) 
If date of birth as an Excel date is in cell A1, then 

=DATEDIF(A1,NOW(),"y")
gives age in completed years, and 

=DATEDIF(A1,NOW(),"ym")
gives the completed months
Handy for the register as well ...

Originally added on Monday, March 31, 03
in category: ilt in maths

Comment on this resource

[ top ]

Use this form to send a comment about this resource. When you send your comment by clicking on the 'Send' button, you will be returned to this page.


(if you want a reply)

Click to send!

[ top ]

Content by Keith Burnett and contributors
Powered by Movable Type 2.63